User Tools

Site Tools


projects:sandbox:database

This is an old revision of the document!


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';
projects/sandbox/database.1673517685.txt.gz · Last modified: 2023/01/12 05:01 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