<FreeKB>
Home
About
Walkthroughs
Postgres (SQL)
Sign In
FreeKB - Postgres (SQL) articles
Postgres (SQL) articles
Authentication
passwordless authentication using the hidden .pgpass file
Back up
Back up a Postgres database using the pg_dump command
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 Linux
Port
List Port using the psql command
Remote Connections
Allow Remote Connections
Status
Display Postgres status
Tables
Create a new table using the psql command
List columns in a 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 "role does not exist"
Users
Create user
Version
Display Postgres version