tosbourn

Simple Postgres Commands I always forget

Here are some simple Postgres commands that I almost always forget

Written by

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

JavaScript

Setting a more specific database type in Prisma

Prisma sets a default of TEXT for all String fields, here is how you can override that.

May 2025

Ruby

Override database attribute types

Sometimes you don't have control over how your database handles information, so you need Rails to set it

May 2025