Differences

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

--- projects:sandbox:database [2023/01/12 05:01] – created jhagstrand
+++ projects:sandbox:database [2023/03/11 01:54] (current) – jhagstrand
@@ Line 7: / Line 7: @@
 Do everything from psql.  \\
-    psql -U voyccom_jhagstrand -d voyccom_mai
+  psql -U voyccom_jhagstrand -d voyccom_mai
-    password is in .pgpass
+  (password is in .pgpass)
-    \h list SQL commands
-    \? list psql commands
+  \h list SQL commands
-    \dt list tables in public schema
+  \? list psql commands
-    SELECT * FROM information_schema.tables WHERE table_schema = 'mai';
+  \dt list tables in public schema
-    SELECT column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'mai';
+  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;