Forum OpenACS Q&A: Re: Running the psql COPY command from db_dml

Collapse
5: Re: Running the psql COPY command from db_dml (response to 1)
Posted by Bruno Mattarollo on 01/10/05 12:31 PM

Use the following in your SQL file:

\copy TABLE_NAME from 'FILE' using delimiters (etc etc)
note the \ and the lack of ; at the end of the line.

Hope this helps