AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Postgres datatypes11/7/2023 Special data typesīesides the primitive data types, PostgreSQL also provides several special data types related to geometric and network. The UUID values guarantee a better uniqueness than SERIAL and can be used to hide sensitive data exposed to the public such as values of id in URL. The UUID data type allows you to store Universal Unique Identifiers defined by RFC 4122 . In addition, JSONB supports indexing, which can be an advantage. The JSON data type stores plain JSON data that requires reparsing for each processing, while JSONB data type stores JSON data in a binary format which is faster to process but slower to insert. PostgreSQL provides two JSON data types: JSON and JSONB for storing JSON data. The array comes in handy in some situations e.g., storing days of the week, months of the year. In PostgreSQL, you can store an array of strings, an array of integers, etc., in array columns. The TIMESTAMPTZ is the PostgreSQL’s extension to the SQL standard’s temporal data types. It is the abbreviation for timestamp with the time zone.
0 Comments
Read More
Leave a Reply. |