default | grid-3 | grid-2

Post per Page

PostgreSQL on the command line

I am just getting back into PostgreSQL.  Here are the things I had to learn today:

1.  Command line usage:
  • su - postgres
  • psql
  • select version();
2.  Dumping data for import on another server
  • pg_dump -o mydb -U postgres -W > mydb.sql
  • -o has to do with oids (Not sure if I need this yet)
  • -U is for user
  • -W is for password.  It prompts when you run the command

No comments

Error Page Image

Error Page Image

Oooops.... Could not find it!!!

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage