18.3 PostgreSQL Basic Meta Commands

$ psql -d iris    # Connect to PostgreSQL with specific database.
kayon=# \l        # List databases.
kayon=# \c iris   # Connect to (use) the specified database.
kayon=# \dt       # List relations (tables).
kayon=# \dt+      # List relations (tables) and sizes.
kayon=# \q        # Quit.


Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.