Skip to content

Haki Benita personal blog

How to Get or Create in PostgreSQL

hakibenita.com published 2024-08-05

And why it is so easy to get wrong...

Read on hakibenita.com → Discuss on HN (24) Archived copy

Points: 103
HN comments: 24
Submissions: 1
Cited by: 0 commenters

Databases & Data Software Engineering 2024

On Hacker News

Submitted	Title on HN	Points	Comments
Aug 5, 2024	How to Get or Create in PostgreSQL by todsacerdoti	103	24

More from Haki Benita

All 11 posts →

Lesser-known Postgres features

2021702 points180 comments Databases & Data details

Practical SQL for Data Analysis

2021602 points191 comments Databases & Data details

Simple Anomaly Detection Using Plain SQL

2021512 points47 comments Databases & Data details

Unconventional PostgreSQL Optimizations

2026431 points69 comments Databases & Data details

An unexpected find that freed 20GB of unused index space in PostgreSQL

2021375 points140 comments Databases & Data details

Some SQL Tricks of an Application DBA

2020327 points68 comments Databases & Data details

Related posts from the same era

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Datomic is Free

Datomic Blog20231,099 points368 commentscited by 5 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

My favourite API is a zipfile on the European Central Bank's website

csvbase Blog20231,024 points265 comments details

The DuckDB Local UI

DuckDB Blog2025926 points188 commentscited by 3 details