1

I was looking at the psql documentation:

\copy { table [ ( column_list ) ] | ( query ) } { from | to } { 'filename' | program 'command' | stdin | stdout | pstdin | pstdout } [ [ with ] ( option [, ...] ) ]

but couldn't quite figure out what are the possible options in the last with clause. Looking at \? \copy in psql doesn't give much information either. Any pointers to what are these options?

The only one I know so far is with csv. I have a space separated file, which I don't know how to \copy into postgres via psql.

  • 2
    From the manual: "All options other than the data source/destination are as specified for COPY" – a_horse_with_no_name Feb 12 '16 at 11:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.