michaelp0730
10/12/2015 - 7:52 PM

Basic commands to start, connect and use PostGreSQL on Cloud 9 IDE

Basic commands to start, connect and use PostGreSQL on Cloud 9 IDE

# Start service:
sudo service postgresql start

# Connect to service
sudo sudo -u postgres psql

# Create PostGres database
sudo sudo -u postgres psql
postgres=# create database "groceries";

# List all databases
sudo sudo -u postgres psql
postgres=# \list

# Use database
postgres=# \connect DBNAME