Home Linux HTML/CSS PHP PostgreSQL Node JS React VR Blog

Helpful PSQL Commands

PostgresqlHelpful Commands

Look over the commands below.

PSQL Cheatsheet

  • \l list databases

  • \dt describe tables

  • \d table_name
  • describe table_name

  • \du describe users

  • \df describe functions

  • \dn describe schemas

  • \conninfo connection information

  • \q quit

In the next lesson we will make a user table and learn select, insert and update. If there are any additional commands you would like to see on this page, plase let me know: @codingcommander

Follow Coding Commanders on:





Previous Lesson | Continue to Next Lesson