Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Try:
COPY TO ... DELIMITED WITH "" WITH CHARACTER TAB
>I have a table that I need to output to a text file. The data needs to be delimited with tab and no quotes around the data.
>
>The command, COPY TO myfile.txt DELIMITED WITH TAB, works except that the data is surrounded by quotes. The following works except that the data is surrounded by the underscore, COPY TO myfile.txt DELIMITED WITH _ WITH CHARACTER TAB.
>
>How can I output my data with each column delimted with only a TAB and no other character?
>
>Thanks,
>
>Jerry
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement