CYBERTEC PostgreSQL Logo

Tag: data type

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

A unique constraint where NULL conflicts with everything

by Laurenz Albe | 01.2023
  I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since […]

UNION ALL, data types and performance

by Laurenz Albe | 12.2022
  A while ago, I wrote about the performance impact of query parameter data types. Recently I encountered a similar […]

ERROR: nextval: reached maximum value of sequence

by Hans-Jürgen Schönig | 09.2022
Fix "ERROR: nextval: reached maximum value of sequence in PostgreSQL" - related to using serial data type to generate auto-increment columns

Time zone management in PostgreSQL

by Laurenz Albe | 05.2022
  Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]

Multiranges in PostgreSQL 14

by Hans-Jürgen Schönig | 04.2022
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.

Query parameter data types and performance

by Laurenz Albe | 03.2022
  Recently, I could help solve a “mysterious” performance problem for a customer. The problem turned out to be a […]

Data Normalization in PostgreSQL

by Michał Małecki | 01.2022
In his blog "Normalization by Osmosis", Michał Małecki gives you an overview of data normalization in PostgreSQL, including normal forms

Cleaning up a large number of BLOBs in PostgreSQL

by Hans-Jürgen Schönig | 04.2021
Basically, there are two ways to delete BLOBs (binary large objects):Change the PostgreSQL configuration or delete the BLOBs in chunks.

PostgreSQL: int4 vs. float4 vs. numeric

by Hans-Jürgen Schönig | 01.2021
PostgreSQL offers many different data types. This post will focus on three important ones: the integer, float and numeric types.

PostgreSQL: Useful new data types - CREATE DOMAIN

by Hans-Jürgen Schönig | 07.2020
UPDATED 08.05.2023 How to create useful new data types with CREATE DOMAIN in PostgreSQL | Advanced server side check constraints
1 2
CYBERTEC Logo white
STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


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

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