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

Productivity

5 ways to speed up your software development

I love feeling like I am speeding through development tasks, here are five things that can help speed up your software development

Accessibility SEO

The main reasons why we shouldn't use click here as link text

There are many reasons why we shouldn't use click here or similar as link text, let's go through them