Ubuntu/postgres
From r00tedvw.com wiki
(Difference between revisions)
(Created page with "==Login as root== <nowiki>~$ sudo su - postgres ~$ psql postgres=#</nowiki> ==List databases== ====List all DBs==== <nowiki>postgres=# \list -OR- \l</nowiki> ====List all t...") |
Revision as of 15:56, 5 June 2015
Contents |
Login as root
~$ sudo su - postgres ~$ psql postgres=#
List databases
List all DBs
postgres=# \list -OR- \l
List all tables in current DB
postgres=# \dt