# 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