Adding line breaks for PSQL commands

Question

How can I do line breaks properly in bash script? The following command works fine without adding line breaks:

for i in {table1,table2,table3}; do psql -U postgres -c "\COPY (SELECT * FROM "DB"."$i") TO "$i".csv DELIMITER ',' CSV"; done

However, I would like add to more table names in the script. I keep getting (Filename too long) error. I would like to do something like the following:

    for i in {table1, \
     table2, \
     table3}; do psql -U postgres -c "\COPY (SELECT * FROM "DB"."$i") TO "$i".csv 
     DELIMITER ',' CSV"; done

But I keep getting the error:

ERROR:  syntax error at or near "}"

Remove the {, }, and ,s between braces.

M. Nejat Aydin
– M. Nejat Aydin

2021-12-01 21:22:28 +00:00
Commented Dec 1, 2021 at 21:22 — M. Nejat Aydin
– M. Nejat Aydin, Commented Dec 1, 2021 at 21:22

Lemayian · Accepted Answer · 2021-12-01 21:27:55Z

2

You don't need curly braces {} to denote an array in bash, just do it like:

for i in table1 \
     table2 \
     table3; do psql -U postgres -c "\COPY (SELECT * FROM "DB"."$i") TO "$i".csv 
     DELIMITER ',' CSV"; done

answered Dec 1, 2021 at 21:27

Lemayian

1957 bronze badges

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

Collectives™ on Stack Overflow

Adding line breaks for PSQL commands

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