Postgresql

From Halfface
Revision as of 12:44, 18 December 2018 by Ekaanbj (talk | contribs) (→‎psql)
Jump to navigation Jump to search

psql

Connect to remote database:

export PGPASSWORD=password && psql --host=10.111.222.1 --port=5492 --username=user --no-password postgres

install psql

apt-get install freetds-bin

List databases

SELECT datname FROM pg_database;