Connect remote PostgreSQL

 psql -U admin -h 192.168.1.5 -p 2506 -d mydatabae

List all databases

 psql -l

List users

 SELECT rolname FROM pg_roles;

Show current database

 SELECT current_database();

Show all tables in database

 \dt

database
List databases

\l

Connect to database
```
\c <database_name>

Show current database

SELECT current_database();

Create database

CREATE DATABASE <database_name> WITH OWNER <username>;

Drop database

DROP DATABASE IF EXISTS <database_name>;

Rename database

ALTER DATABASE <old_name> RENAME TO <new_name>;

*** Tables ***
List tables, in current db

\dt

SELECT table_schema,table_name FROM information_schema.tables ORDER BY
table_schema,table_name;

List tables, globally

\dt ..

```
SELECT * FROM pg_catalog.pg_tables

List table schema

\d <table_name>
 \d+ <table_name>

 SELECT column_name, data_type, character_maximum_length
 FROM INFORMATION_SCHEMA.COLUMNS
 WHERE table_name = '<table_name>';

Create table

CREATE TABLE <table_name>(
  <column_name> <column_type>,
  <column_name> <column_type>
 );

Create table, with an auto-incrementing primary key

CREATE TABLE <table_name> (
  <column_name> SERIAL PRIMARY KEY
 );

Delete table

DROP TABLE IF EXISTS <table_name> CASCADE;