Les Partages de Memiks
Tag cloud
Picture wall
Daily
RSS Feed
  • RSS Feed
  • Daily Feed
  • Weekly Feed
  • Monthly Feed
Filters

Links per page

  • 20 links
  • 50 links
  • 100 links

Filters

Untagged links
postgresql - How do I list all databases and tables using psql? - Database Administrators Stack Exchange https://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql
Wed Feb 27 23:56:32 2019 archive.org
QRCode
thumbnail

Please note the following commands:

\list or \l: list all databases
\dt: list all tables in the current database

You will never see tables in other databases, these tables aren't visible. You have to connect to the correct database to see its tables (and other objects).

To switch databases:

\connect database_name or \c database_name

http://www.postgresql.org/docs/current/interactive/app-psql.html

postgresql table list
4759 links, including 1673 private
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn