MySQL and PostgreSQL Command Comparison

Command Comparison

PostgreSQL/MySQL information_schema

Table list

Column list

Setup Default Connection

export PGDATABASE = DB name
export PGHOST = host
export PGPORT = port number
export PGUSER = username
export PGPASSWORD = password
[client]
database = DB name
user = username
password = password