1 / 9

PostgreSQL Data Types

A data type (or) only types refers to the specific type of data that the variable holds. Moreover, these include the date, timestamps, varchar, and some other formats.

ducathub
Download Presentation

PostgreSQL Data Types

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PostgreSQL Data Types The PostgreSQL is a database that manages multiple values of data. What is the data type? A data type (or) only types refers to the specific type of data that the variable holds. Moreover, these include the date, timestamps, varchar, and some other formats.

  2. Numeric Datatypes PostgreSQL supports two types of Numeric datatypes, including integers and Floating point numbers.

  3. Monetary data types This is the detailed data that the database provides. Here in this data type, numeric values, int and bigint can be modified into money. So now many person say that we can use Float datatype. But this is not recommended to manage money due to the potential for rounding bugs. Character data types The following table includes the PostgreSQL character datatypes.

  4. Date/time data type The date/time datatype is used to represent the columns using the date and time values.

  5. Geometric data types The geometric data types represent two-dimensional data objects. Moreover, these data types help to perform various operation like rotation, scaling and translation etc. Network Address type Today we do have many network address types like IPV4, IP V6, and MAC address. Moreover, this PostgreSQL offers different data types to store in this address.

  6. It can store in a network address, instead of plain text, it is preferable to keep these data types. Enumerated data types In PostgreSQL, enumerated data types are useful for representing the rarely changing information such as country code (or) branch id. So to ensure data integrity, the enumerated data type is defined with a table with a foreign key. Range type These represent data that uses the data range. These range types can be a discrete range (or) continuous ranges.

  7. Pseudo types PostgreSQL contains several special-purpose entries that are collectively called as pseudotypes. Moreover, a pseudo data type cannot be used as a column data type that can be used as a column data type. Additionally, this can be used to declare a function argument (or) a result type.

  8. THANK YOU CONTACT 70-70-90-50-90 Email info@ducatindia.com

More Related