notes

Log | Files | Refs

psql.txt (719B)

      1 PSQL
      2 
      3 Show hidden/system schemas:
      4 \dnS
      5 
      6 Show hidden/system tables (all schemas):
      7 \dtS *.*
      8 
      9 Show hidden/system tables in one schema:
     10 \dtS pg_catalog.*
     11 
     12 Describe a table including system columns:
     13 \dS+ table_name
     14 
     15 List all schemas via SQL:
     16 SELECT nspname FROM pg_namespace ORDER BY nspname;
     17 
     18 List all tables via SQL (including system):
     19 SELECT schemaname, tablename FROM pg_tables ORDER BY schemaname, tablename;
     20 
     21 Connect and execute:
     22 psql -h localhost -U myuser -d mydb -c "SELECT * FROM users LIMIT 5"
     23 
     24 Export to CSV:
     25 psql -h localhost -U myuser -d mydb -c "SELECT * FROM users" --csv > users.csv
     26 
     27 Batch Query (no header, comma separated):
     28 psql -h localhost -U myuser -d mydb -t -A -F',' -c "SELECT id, email FROM users"