postgres \c with linebreaks

Question

I'm creating an export to csv that's a rather long query, as such, I placed the \copy command in a new file. The problem is that the newlines seem to break my command, is there a way I'm able to execute this command with line breaks?

For example:

\copy (select
        field1
        , field2
    FROM table
) to '/tmp/out.csv' csv;

I'm currently running that command from a sql file as such:

psql -f tocsv.sql

I don't think it matters that I'm running it from a file. Is there a way to execute the copy command with the line breaks in my query? I'd like to keep them there for legibility.

tr -d '\n' < tocsv.sql | psql

Mike Organek
– Mike Organek

2022-06-10 22:04:29 +00:00
Commented Jun 10, 2022 at 22:04 — Mike Organek
– Mike Organek, Commented Jun 10, 2022 at 22:04

Adrian Klaver · Accepted Answer · 2022-06-10 21:20:11Z

1

From here psql in \copy section:

Tip

Another way to obtain the same result as \copy ... to is to use the SQL COPY ... TO STDOUT command and terminate it with \g filename or \g |program. Unlike \copy, this method allows the command to span multiple lines; also, variable interpolation and backquote expansion can be used.

answered Jun 10, 2022 at 21:20

Adrian Klaver

20.3k3 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgres \c with linebreaks

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related