use sql file in "\copy" psql command line

Question

I'm trying to script a query from a bash file but the select query is in a file. For compatibility and test, I'd like to keep it this way.

In short I'd like to write something like:

psql -c data_base "\copy (<file.sql>) To './test.csv' With CSV"

Would you know how to do that ?

EDIT

The "file.sql" contains a query :

$cat file.sql
$SELECT country FROM world;

Your requirement is not clear. Can you explain it with a sample input and an expected output. — Inian
– Inian, Commented Feb 6, 2017 at 10:24
The <file.sql> isn't a real sequence. It 's the file containing the query, i'm trying to pass it to the \copy command. — Mehdi_debout
– Mehdi_debout, Commented Feb 6, 2017 at 10:42

Laurenz Albe · Accepted Answer · 2017-02-06 11:00:39Z

8

You can use bash substitution as,

psql -c data_base "\copy ($(<file.sql)) To './test.csv' With CSV"

$(<file) expands the contents of the file

edited Feb 6, 2017 at 11:00

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

answered Feb 6, 2017 at 10:50

Inian

87k15 gold badges166 silver badges183 bronze badges

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

6 Comments

Laurenz Albe Over a year ago

I have added parentheses because those those are needed when you use a query with COPY.

Inian Over a year ago

@LaurenzAlbe: Appreciate it! Cheers!

Mehdi_debout Over a year ago

still testing, ;-) There's issue with a more complex query ( containing parentheses or quotes )

Maximilian Lindsey Over a year ago

This was very helpful and worked perfectly for me, thanks

kartikmaji Over a year ago

I tried the same with $(<file). I am getting -bash: /usr/bin/psql: Argument list too long Edit: My command psql -h DB_HOST DB_NAME DB_USER -c "\copy ($(</tmp/prod_get_carrier_tier_dbcfg.sql)) To './test1.csv' With CSV"

|

Collectives™ on Stack Overflow

use sql file in "\copy" psql command line

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related