Skip to content

PostgreSQL: Add columns to a query table with variables

G3rd July 2020 

CNo comments

Generate a new column in your PostgreSQL database query from data in other columns or other tables.

Read the full story

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 

C2 comments

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

Read the full story