Postgresql: Difference between revisions
Jump to navigation
Jump to search
(→psql) |
|||
Line 6: | Line 6: | ||
=List databases= | =List databases= | ||
1 | |||
SELECT datname FROM pg_database; | SELECT datname FROM pg_database; | ||
2 | |||
\l |
Revision as of 13:05, 18 December 2018
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
1
SELECT datname FROM pg_database;
2
\l