[[projects:projects]]:[[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 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;