Tag: sql help

Get the Newest PostgreSQL Info, Tips & Tricks

Here you can find all blog posts about the Tag: sql help. You can go back to all blog posts or take a look into our other categories & tags.

TDE: A dive into encrypted data

by Andreas Kretschmer | 02.2024

How to check if TDE works? Some days ago a customer asked me how to check if TDE works and […]

How To

ERROR: current transaction is aborted in PostgreSQL

by Hans-Jürgen Schönig | 10.2023

Whenever you actively use transaction blocks in PostgreSQL “ERROR: current transaction is aborted, commands ignored until end of transaction block” […]

How To

Kill long running queries in PostgreSQL

by Hans-Jürgen Schönig | 10.2023

How to terminate long running queries in PostgreSQL: People might be fans of SQL, people might like PostgreSQL on Kubernetes […]

How To & Performance

Citus: 7 commonly used advanced SQL tools

by Hans-Jürgen Schönig | 09.2023

When you run advanced SQL in Citus, what's possible? Which SQL statements work, and which ones don't? Citus is a […]

How To

"hired" vs. "fired" - fuzzy search in PostgreSQL

by Hans-Jürgen Schönig | 09.2023

When dealing with data (and life in general) small things can have a major impact. The difference between “hired” and […]

How To

Exclusion constraints in PostgreSQL and a tricky problem

by Christoph Berg | 09.2023

Exclusion constraints are a feature that is not very well known, but can be used to implement highly sophisticated constraints. […]

How To

Conditional foreign keys and polymorphism in SQL: 4 Methods

by Laurenz Albe | 08.2023

This article is about the notoriously difficult problem of “conditional foreign keys”. In object-oriented programming languages, polymorphism is a […]

How To