Hi,

Good Morning.

I'm trying to use the COPY command but for some reason i'm unable to make
it work.

As per the doc, below is the query syntax:

*copy*  *conflict-algorithm*   *table-name *  *file-name *     ?
*column-separator*?   ?*null-indicator*?


I have created a file with data and tried all the below commands:

*Case 1:* Data in input file(data.dat) has "," as column-separator

copy rollback employee /Volumes/Official/data.dat ',' ;

*Case 2:* Data in input file(data.dat) has "\t"(Default) as column-separator

copy rollback employee /Volumes/Official/data.dat;

Unfortunately nothing is working. Also i tried almost all possible
combinations but nothing worked :(

Always i'm getting same error

*Error: near "copy": syntax error *
Please help me in this regard.

Awaiting your response.

Thanks & Best Regards,
- Mahi

Reply via email to