postgresql: run SQL commands using psql in commandline

Question

I have the below three lines to be run in commandline using psql how can i do it.

CREATE DATABASE myproject;
CREATE USER myprojectuser WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE myproject TO myprojectuser;

I just want to pass the sql strings as it is.

Possible duplicate of How to execute multiple queries using psql command from bash shell? — Gregory Arenius
– Gregory Arenius, Commented Mar 19, 2019 at 22:04

Scoots · Accepted Answer · 2020-10-13 20:24:16Z

6

As per the docs psql -c 'command;'

psql -c 'CREATE DATABASE myproject;' -c "CREATE USER myprojectuser WITH PASSWORD 'password';" -c 'GRANT ALL PRIVILEGES ON DATABASE myproject TO myprojectuser;'

edited Oct 13, 2020 at 20:24

answered Mar 19, 2019 at 13:44

Scoots

3,1142 gold badges25 silver badges35 bronze badges

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

Comments

Kaushik Nayak · Accepted Answer · 2019-03-19 13:48:39Z

3

As @horse suggested -f filename is a better option. You can also put them into a variable using a here document and execute it with the -c option .

read -r -d '' my_sqls << EOM
CREATE DATABASE myproject;
CREATE USER myprojectuser WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE myproject TO myprojectuser;
EOM
psql -c "$my_sqls"   # running all  the lines.

answered Mar 19, 2019 at 13:48

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

1 Comment

tripleee Over a year ago

The temporary variable is just a complication; Bash trivially allows you to pass a multi-line string basically anywhere you can put a string which doesn't contain newlines.

Collectives™ on Stack Overflow

postgresql: run SQL commands using psql in commandline

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related