One Thing You Wish You Knew While Learning PostgreSQL: PGSqlPhriday #006

I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m interested in that one thing that you wish someone had told you. That tiny bit of “AH HA!!!” information that you have now, but it took you a while to find. Just that teeniest, tiniest slice of the behavior of PostgreSQL that proved to be a game-changer for you.

In short, help me and all the others out there trying to learn this stuff. Make learning PostgreSQL just a little bit faster & easier for us. Please.

Why am I asking? Because this is all a part of #PGSqlPhriday 006.

What is #PGSqlPhriday and how do I participate?

As to what #PGSqlPhriday is, it’s just a monthly, community driven, blogging event. One person volunteers to ask a question (Hi! My name is Grant) and then a bunch of people answer that question in their own way on their own blogs. That’s it. Nice and simple. There isn’t a wrong way to answer, just your way. It drives traffic and helps us all interact more and better.

There are some official rules summarized here.

  • Publish your blog post about “One Thing You Wish You Knew While Learning PostgreSQL” before, or on, Friday, March 3rd, 2023
  • Include “PGSQL Phriday #006” in the title or first paragraph of the blog posting
  • Link back to this blog post (the one you’re reading, and this is important so I can include you in the later summary)

Announce your blog post in one or any of these places:

  • Twitter (or Mastodon) using the #PGSQLPhriday hashtag
  • PostgreSQL Slack in the #PGSQLPhriday channel
  • Interact with other blog posts about this topic


This is a fun and simple way to come up with topics for blogging. It’s a great way to share your knowledge with others. So, please, do let me know, what’s the one thing I need to really raise the bar in my PostgreSQL knowledge and skills.

Please let me know what you think about this article or any questions:

This site uses Akismet to reduce spam. Learn how your comment data is processed.