postgresql commands

gistfile1.txt

Location:

    /Applications/Postgres.app/Contents/MacOS/bin/psql

JDBC Properties:

    database.driverClassName=org.postgresql.Driver
    database.url=jdbc\:postgresql\://localhost\:5432/salesquote
    database.username=
    database.password=

Start command:

    psql 

Create database:

    create database salesquote

Help:

    \?

List Databases:

    \list
    select * from pg_database where datistemplate  = false;

List tables:

    \dt