User Tools

Site Tools


sandbox_database

This is an old revision of the document!


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';
 
  
  
sandbox_database.1670209199.txt.gz ยท Last modified: 2022/12/04 21:59 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