PostgreSQL

From Dryad wiki
Revision as of 07:49, 9 June 2008 by Ryan Scherle (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

DSpace uses the PostgreSQL database by default.

Common Commands

\c [name]
Connect to a database (like "dspace")
\d [name]
Describes the format of a table, view, sequence, etc.
\dt
List all tables in the database
\h 
help with postgres
\q 
quit
\? 
help with sql