PostgreSQL and psql trivia commands

Expanded mode

SELECT * FROM storage.objects LIMIT 4\gx

Create user and table

CREATE ROLE salesapp WITH LOGIN PASSWORD 'your_password';
CREATE DATABASE sales OWNER salesapp;
 
-- if the user doesn't have SET ROLE permission
CREATE ROLE salesapp WITH LOGIN PASSWORD 'your_password' CREATEDB;
-- and then CREATE DATABASE as the new role

Administrator guide

Full export

PGPASSWORD="..." pg_dumpall -f xxx_full.sql -d 'postgresql://user@...'

Export DB schema

pg_dump --schema-only --dbname 

SELECT * FROM supabase_functions.migrations;