PostgreSQL Practice Repository

This is a GitHub repository where I write and share SQL tips and tricks that I learned while working or studying. Feel free to copy and use whatever you need!

Remark : I am using both PostgreSQL 13 and 15 versions interchangeably.
If a code snippet only works in version 15,
I will indicate it with a comment.

🧭 Coding History

Here is a list of tasks that I have done so far.

• How To Create Temporary Sample Data

  When you occasionally need to test something very quickly
  and there is no table available, there are cases where you
  need a temporary data set. Here's a way to create one.
  

  • using values() syntax
  • generate_series practice