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

Web Dev

Updating payment method email addresses in Stripe

You can't update the email address associated with a payment method in Stripe via their dashboard, you need to use the Stripe CLI

Ruby

Irreversible Rails Migrations

What are irreversible migrations and how might we use them to our advantage?