[[postgres]]
 
Trace: » postgres
Table of Contents

Postgres

Logging in:

su - postgres
psql <database>

Common Commands

\dt - show tables
\l - show databases
\d <table> - describe table

Command line tools

Dump database

pg_dump <dbname> >file
 
postgres.txt · Last modified: 2009/04/21 09:12 (external edit)
 
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki