Differences

This shows you the differences between two versions of the page.

--- projects:sandbox:database [2023/03/11 01:54] – [database] jhagstrand
+++ projects:sandbox:database [2023/03/11 01:54] (current) – jhagstrand
@@ Line 9: / Line 9: @@
   psql -U voyccom_jhagstrand -d voyccom_mai
   (password is in .pgpass)
   \h list SQL commands
   \? list psql commands
   \dt list tables in public schema
   SELECT * FROM information_schema.tables WHERE table_schema = 'mai';
   SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'mai';
   select table_schema, table_name from information_schema.tables where table_schema not in ('public','pg_catalog','information_schema') group by table_schema, table_name order by table_schema,table_name;