psql.exe postgresql create database via CMD

Question

I search to create a database via CMD, i success to create it using this command:

C:\>"C:\Program Files\PostgreSQL\9.3\bin\psql.exe" -U postgres template1

So when i excute this command i can Create my database like this:

template1=# CREATE DATABASE d_base;

My objectif is to create this database with just one line:

like this:

 C:\>"C:\Program Files\PostgreSQL\9.3\bin\psql.exe" -U postgres template1 "CREATE DATABASE T;"

But this not work with me, it gave me this error:

i can solve this problem with creating a .bat Script but my objectif is to use just one line,

Is there any solution for that.

Thank you.

Laurenz Albe · Accepted Answer · 2016-08-29 12:31:40Z

2

You get that error because template1 is not the last argument. You can use -d to specify the database.

Use the database postgres instead of template1.

Try this:

"C:\Program Files\PostgreSQL\9.3\bin\psql.exe" -U postgres -d postgres -c "CREATE DATABASE t"

answered Aug 29, 2016 at 12:31

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Comments

Boris Schegolev · Accepted Answer · 2016-08-29 12:31:25Z

2

see --command=command section

answered Aug 29, 2016 at 12:31

Boris Schegolev

3,7115 gold badges23 silver badges35 bronze badges