Postgresql: Difference between revisions
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
=select database= | =select database= | ||
\c testdb; | \c testdb; | ||
=show tables= | |||
\dt | |||
=Change view. One line per attribute= | |||
\x on | |||
Revision as of 13:18, 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
select database
\c testdb;
show tables
\dt
Change view. One line per attribute
\x on