Skip to content

PostgreSQL: Store a PSQL COUNT query result as a Bash variable

G5th June 2018 

CNo comments

Use this nifty code to isolate the result of a PSQL COUNT query as a variable within a Bash script.

Read the full story

Create a non-superuser role in PostgreSQL

G18th April 2018 

CNo comments

Use this easy procedure to establish a non-superuser role in PostgreSQL.

Read the full story

Export a PostgreSQL query to a CSV

G24th November 2017 

CNo comments

Export the contents of a database table to a CSV file using the psql PostgreSQL utility in PuTTY.

Read the full story