Cameron Laird's personal notes on Postgres
Almost all my Postgres-ing uses the
Tcl extension which
accesses Postgres. It's easy to use; package require
Pqa
loads it.
PostgreSQL Home
Download PostgreSQL
PostgreSQL
manual pages
POSTGRES95
User Manual
I compare PostGreSQL to
other data management systems.
Frequently-used commands:
- Connect to database mydatabase:
psql mydatabase
.
It's most likely that template1
will be available.
- Show all databases:
\l
(from within psql)
- Show tables within database:
\d
- Show columns with table mytable:
\d mytable
- Leave psql:
\q
Cameron
Laird's personal notes on
Postgres/claird@phaseit.net