\l - Display database
\c - Connect to database
SHOW search_path;
SET search_path TO myschema,public;
psql 'postgresql://myUser@myHost:myPort/myDb?options=--search_path%3dmyschema'
\dn - List schemas
\dt - List tables inside public schemas
\d tablename|view
\dt tablename
\di indexname
\ds sequename
\dv viewname
\df functioname
OPERATOR(schema.operator) - OPERATOR(myschema.%)
\dx - SELECT * FROM pg_extension; SELECT * FROM pg_available_extensions;
\encoding [utf-8]
show [client_encoding|server_encoding]
\q
select * from pg_tables;
select tablename from pg_tables where schemaname='public';
\set PROMPT1 '%001%[%033[1;32;40m%]%002%n@%/%R%001%[%033[0m%]%002%# '
\set PROMPT1 '%001%[%033[1;33;40m%]%002%n@%/%R%001%[%033[0m%]%002%# '
\set PROMPT1 '%001%[%033[1;32;40m%]%002%M_%/%R%001%[%033[0m%]%002%# '