Home

Select from table Select from another query Save query to a variable, and use that variable with another select Using the results of another query as a condition

Broadcast message on all ports:

Connect to database: Turn on headers (default: off) Select mode (default: list) Run your query

Create user: Create a database: Grant user to database: Grant user to schema: Configure the server: Configure server access: Restart posgresql:

Connect to psql via console: Description Command List database \list \l List database with extra information \list+ \l+ Connect to a database \connect <database-name> <username> \c <database-name> <username> List tables \dt Describe a table \d Describe a table with extra information \d+ List schemas \dn List user and roles \du List functions \df List views…

References: