How do I add '\c' to a psql command executed from a bash script?

Question

To set up my project, I have to do quite a few commands and I'm trying to script this away. Some of these are in psql; so normally I'd go

psql -U postgres -h localhost -p 5433
(psql) create database test_database
(psql) \c test_database
(psql) \i integration-test/src/test/resources/init.sql

The .init.sql contains stuff to fill the database with mock data.

In my bash script, I tried reducing this to

psql -U postgres -h localhost -p 5433 -c "create database test_database; \c test_database; \i integration-test/src/test/resources/init.sql"

However, this gets me

ERROR:  syntax error at or near "\"
LINE 1: create database test_database; \c fcs_analytics; \i integrat...
                                   ^

How do I execute these commands properly from my script?

Philippe · Accepted Answer · 2021-10-03 12:05:36Z

3

Have you tried ?

psql -U postgres -h localhost -p 5433 << 'EOF'
create database test_database
\c test_database
\i integration-test/src/test/resources/init.sql
EOF

answered Oct 3, 2021 at 12:05

Philippe

27.7k4 gold badges28 silver badges45 bronze badges

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

2 Comments

Teresa Over a year ago

Thanks for that! So appending multiline commands as a string is simply a no-go?

Philippe Over a year ago

Appending multiline commands as a string can still work, but dealing with quotes and backblashes is too much hassle.

Collectives™ on Stack Overflow

How do I add '\c' to a psql command executed from a bash script?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related