Wednesday, August 23, 2017

fastest way to access PostgreSQL from bash

used win10 bash for that.

sudo apt-get install postgresql-client-common
sudo apt-get install postgres-xc-client
psql -h <server> -p <port> -U <user> -d <database-name>
db=> select * from information_schema.tables;