I am just getting back into PostgreSQL. Here are the things I had to learn today:
1. Command line usage:
1. Command line usage:
- su - postgres
- psql
- select version();
- 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
Comments
Post a Comment