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
    Type 1 or more characters for results.
    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
    4683 links, including 1597 private
    Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn