(TIL) PSQL: Send A Command To psql

less than 1 minute read

You can send a command to psql to be executed by using the -c flag

$ psql -c "select 'Hello, World!';"
   ?column?
---------------
 Hello, World!
(1 row)

Specify a particular database as needed

$ psql blog_prod -c 'select count(*) from posts;'
 count
-------
     8
(1 row)

Via jbranchaud/til.

Comments