![]() 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. TIMESTAMPTZ is a timezone-aware timestamp data type.TIMESTAMPstores both date and time values. ![]() PostgreSQL has five main temporal data types: The temporal data types allow you to store date and /or time data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |