Rename a column from an existing table ALTER TABLE table_name ALTER COLUMN column_name.Rename a column from an existing table ALTER TABLE table_name RENAME COLUMN column_name TO new_column_name.Drop a column from an existing table ALTER TABLE table_name DROP COLUMN column_name.Add a column to an existing table ALTER TABLE table_name ADD COLUMN new_column_name TYPE.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: Object-oriented and ANSI-SQL 2008 compatible Data types in PostgreSQL:.Log-based and trigger-based replication SSL.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.

Mac cheat sheet for algebra