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

Forcing a Rails database column to be not null

How you can force a table column to always have something in it with Rails

Writing Marketing

We've deleted an article's worth of unhelpful words

We've improved several pages across our site by removing words that add no value, and often detract from the article.