Category: How To

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Category: How To. You can go back to all blog posts or take a look into our other categories & tags.

Reducing the number of columns with bit

by Hans-Jürgen Schönig | 08.2013
After digging through a table consisting of dozens of boolean values I thought it might be helpful to more folks […]

Time in PostgreSQL: Outer joins

by Hans-Jürgen Schönig | 08.2013
UPDATED AUGUST 2023: After my previous post, I received mails asking about what was meant by using “generate_series” in an […]

Time in PostgreSQL: The simple way

by Hans-Jürgen Schönig | 08.2013
UPDATED August 2023: Time is one of those unloved topics every programmer has to deal with. Have you ever written […]

CREATE TABLE – the fancy way with LIKE

by Hans-Jürgen Schönig | 05.2013
One tiny little feature many users of PostgreSQL have often forgotten is the ability to create similar tables. It happens […]

Kostal Pico to PostgreSQL

by Hans-Jürgen Schönig | 05.2013
Everybody needs a little toy to play with, so I thought: Why not buy a toy helping me to get […]

GIN - Just A Kind Of Index

by Hans-Jürgen Schönig | 03.2013
As far as PostgreSQL is concerned, GIN means an access method (index type) rather than a drink. The acronym stands […]

PostgreSQL 9.3: "One line - one standby"

by Hans-Jürgen Schönig | 01.2013
Sometimes it happens that you reach a point where you know that things cannot be any easier than they already […]

Removing duplicates in PostgreSQL

by Hans-Jürgen Schönig | 12.2012
Today somebody asked me how to remove duplicates which accidentally made it into a table. The problem is: A normal […]

Why the tax collector hates sequences

by Hans-Jürgen Schönig | 09.2012
I guess people might wonder why I started to write posts about taxes. Well, I pay my taxes for my […]

Outer joins revisited

by Hans-Jürgen Schönig | 08.2012
Some time ago I wrote about joins and especially about outer joins. However, people repeatedly make the same errors over […]
1 32 33 34
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram