Run SQL Query In Terminal

To run a SQL query, you use CLI(psql) or GUI(pgadmin/metabase) program to execute the query. Sometimes, you want to run the command to look a table structure and number of records in the table without worrying about opening the client. So rather than running the CLI client, you can pass the query string to psql command with the flag, -c.

The command looks like

$psql -h localhost -d typeboard -c "select count(*) from project"
(1 row)