FreeKB - Postgres (SQL) articles
Postgres (SQL) articles

Authenticationpasswordless authentication using the hidden .pgpass fileBack upBack up a Postgres database using the pg_dump commandConfigMax ConnectionsdatabasesCreate database using the createdb or psql commanddrop database using the psql commandlist databases using the psql commandInstallInstall Postgres on LinuxPortList Port using the psql commandRemote ConnectionsAllow Remote ConnectionsStatusDisplay Postgres statusTablesCreate a new table using the psql commandList columns in a table using the psql commandlist tables in a database using the psql commandSELECT data in a table on OpenShiftTroubleshootingResolve "duplicate key value violates unique constraint"Resolve "role does not exist"UsersCreate userVersionDisplay Postgres version