User Tools

Site Tools


sandbox_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
sandbox_database [2022/09/22 23:53] – created jhagstrandsandbox_database [2023/01/12 05:00] (current) – removed jhagstrand
Line 1: Line 1:
-====== 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'; 
  
sandbox_database.1663905201.txt.gz · Last modified: 2022/09/22 23:53 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