tinyzero4 tinyzero4

## postgres-cheatsheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                tinyzero4
                / postgres-cheatsheet.md
            
            
              Created
              March 6, 2019 11:54
                — forked from Kartones/postgres-cheatsheet.md
            
              
                PostgreSQL command line cheatsheet
              
          
    PSQL

Magic words:
psql -U postgres
Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)


## postgres cheatsheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                tinyzero4
                / postgres cheatsheet.md
            
            
              Created
              March 6, 2019 11:52
                — forked from apolloclark/postgres cheatsheet.md
            
              
                postgres cheatsheet
              
          
    Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.
Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/
https://help.ubuntu.com/community/PostgreSQL