PostgreSQL supports the various actions to perform with ALTER TABLE as listed below: The structure of an existing table can be modified using the ALTER TABLE statement. These are the reserved words used in WHERE clause to perform operations. Operators in PostgreSQL:Īn operator manipulates individual data items and returns a result. pg_lsn type: pg_lsn (stores Log Sequence Number).Range Data types: int4range, int8range, numrange, tsrange (timestamp range), daterange.BitString types: bit(n), bit varying(n).Pseudo types: any, anyelement, anyarray, anyenum, anyrange, internal, record, trigger, event_trigger.
Network Address types: cidr, inet, macaddr.UUID Data type: uuid (stores Universally Unique Identifiers).JSON Data types: string, number, boolean, null.Geometric Data types: point, line, box, path, polygon, circle, lseg.Binary Data type: bytea (supports hex and escape format).Date/Time Data types: timestamp, date, time, interval.Character Data types: varchar(n), text, char(n).Numeric Data types: smallint, integer, bigint, decimal, numeric, real, serial.PostgreSQL Data Types Numeric Character Date/Time Monetary Binary Boolean Geometric JSON Enumerated Text-Search UUID Network Address Types Composite Object Identifiers Pseudo BitString XML Range Arrays pg_lsn The following table list all the data types available in PostgreSQL:
It supports advanced data types and performance optimization features, like Ms-SQL Server and Oracle. PostgreSQL is a powerful, open-source object-relational database system that aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments. ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys.GATE CS Original Papers and Official Keys.
0 kommentar(er)
