IT Nursery > News > psql

psql

How do I specify a password to ‘psql’ non-interactively?

I am trying to automate database creation process with a shell script and one thing I’ve hit a road block with passing a ...

May 3, 2022
0 Comments

Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in ...

April 28, 2022
0 Comments

psql: FATAL: database “” does not exist

I’m using the PostgreSql app for mac (http://postgresapp.com/). I’ve used it in the past on other machines but it’s giving me some trouble ...

April 18, 2022
0 Comments

How to switch databases in psql?

In MySQL, I used use database_name; What’s the psql equivalent? 1 15

April 13, 2022
0 Comments

How to exit from PostgreSQL command line utility: psql

What command or short key can I use to exit the PostgreSQL command line utility psql? 8 Type \q and then press ENTER ...

April 10, 2022
0 Comments

PostgreSQL “DESCRIBE TABLE”

How do you perform the equivalent of Oracle’s DESCRIBE TABLE in PostgreSQL (using the psql command)? 2 22 Try this (in the psql ...

April 10, 2022
0 Comments