Simple Postgres Commands I always forget

Here are some simple Postgres commands that I almost always forget

I am a simple man with simple needs. Here are the Postgres commands I use most often that I always forget so have written them here.

  • Connecting in locally – psql -d db_name
  • Listing databases – \l
  • Listing tables – \d
  • Listing schemas - \dn
  • Connecting to a different table – \c
  • Getting help with these \ commands – \?
  • Quitting – \q

I fully expect I will be the only reader of this post!


Recent posts View all

Ruby

Upgrading Ruby - Steps to follow

Here are the steps you should follow to upgrade Ruby as stress free as possible

Team Management

Meeting Agendas (and why you should have them)

Please, please, please add meeting agendas to your meeting invites