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 table_schema, table_name, column_name, data_type FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '<table_name>';

sandbox_database.1670208736.txt.gz ยท Last modified: 2022/12/04 21:52 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