CYBERTEC 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.

PostgreSQL: int4 vs. float4 vs. numeric

by Hans-Jürgen Schönig | 01.2021
Data types are an important topic in any relational database. PostgreSQL offers many different types, but not all of them […]

PostgreSQL: Useful new data types - CREATE DOMAIN

by Hans-Jürgen Schönig | 07.2020
UPDATED 08.05.2023 - SQL and especially PostgreSQL provide a nice set of general purpose data types you can use to […]

PostgreSQL: ltree vs. WITH RECURSIVE

by Hans-Jürgen Schönig | 06.2020
After my last post about ltree and recursive data in PostgreSQL people have asked me privately about performance issues. To […]

Binary data performance in PostgreSQL

by Laurenz Albe | 05.2020
  A frequently asked question in this big data world is whether it is better to store binary data inside […]

Mapping Oracle datatypes to PostgreSQL

by Hans-Jürgen Schönig | 05.2018
(updated 2023-05-08) For those of you out there working with PostgreSQL in a professional way, migrating from Oracle to PostgreSQL […]

What PostgreSQL Full-Text-Search has to do with VACUUM

by Hans-Jürgen Schönig | 03.2018
What does PostgreSQL Full-Text-Search have to do with VACUUM? Many readers might actually be surprised that there might be a […]

Joining data from multiple Postgres databases

by CYBERTEC Guest | 08.2017
BY Kaarel Moppel - With the heyday of big data and people running lots of Postgres databases, sometimes one needs […]

int4 vs int8 vs uuid vs numeric performance on bigger joins

by CYBERTEC Guest | 04.2017
Some weeks ago at pgDay Paris, during the evening social event, we got into a small "guestimation" with another Postgres […]

CREATE CAST: Casting integer to IP in PostgreSQL

by Hans-Jürgen Schönig | 05.2014
Once in a while, you have to juggle around with IP addresses and store them / process them in an […]

CREATE DOMAIN: Data type abstraction

by Hans-Jürgen Schönig | 10.2013
If a good programmer is facing a technical problem, he will always try to abstract the problem. In a procedural […]
1 2 3
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

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.

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