User Tools

Site Tools


projects:sandbox:database

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

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki