Postgres (SQL) articles

---

Authentication passwordless authentication using the hidden .pgpass file Backup and Restore Backup a Postgres database using the pg_dump command Migrate a Postgres database using pgloader Restore a Postgres database using the psql command Columns Add a column to a table List columns in a table using the psql command Update Column Type Config Max Connections databases Create database using the createdb or psql command drop database using the psql command list databases using the psql command Install Install Postgres on Docker Install Postgres on Linux Port List Port using the psql command Python Connect to Postgres database using Python Remote Connections Allow Remote Connections Status Display Postgres status Tables Create a new table using the psql command list tables in a database using the psql command SELECT data in a table on OpenShift Troubleshooting Resolve "duplicate key value violates unique constraint" Resolve "Peer authentication failed for user" Resolve "role does not exist" Users Create user Reset a users password Version Display Postgres version whitespace Remove whitespace from a column