Differences

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

--- sandbox_database [2022/12/04 21:52] – jhagstrand
+++ sandbox_database [2023/01/12 05:00] (current) – removed jhagstrand
@@ Line 1: / Line 1: @@
-====== sandbox database ======
-The A2 Hosting installation of phpPgAdmin is bogus.  \\
-There is no way to login.  \\
-Do everything from psql.  \\
-    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 table_schema, table_name, column_name, data_type
-FROM INFORMATION_SCHEMA.COLUMNS
-WHERE table_name = '<table_name>';