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:

YouTube

Facebook

Instagram

Twitter


Previous Lesson | Continue to Next Lesson