postgres:postgresql
This is an old revision of the document!
Table of Contents
PostGreSQL
Open sql cli interface
psql -U [username] -W [password]
Creating/Deleting users
createuser -S -D -R -P -h localhost -U postgres [username] dropuser [username]
Creating a database
createdb -O [owner] -h localhost [dbname]
Import/export a database
psql -U [username] -W [dbname] < dump.sql pg_dump -U [username] -h localhost [-t [table]] [dbname] > dump.sql
postgres/postgresql.1266490295.txt.gz · Last modified: 2010/02/18 11:51 by deva