projects:sandbox:database
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;
projects/sandbox/database.txt · Last modified: 2023/03/11 01:54 by jhagstrand