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.

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 […]

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 […]

Import stock market data into PostgreSQL

by Hans-Jürgen Schönig | 09.2013
Many people I know are doing some private stock market investment. Some of them just want to become rich people […]

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 […]
1 2
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