https://wiki.ispirer.com/ 2026-04-28T01:20:31+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/bigint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - BIGINT Versions: PostgreSQL 8.x and 7.x PostgreSQL - BIGINT Syntax BIGINT Data 64-bit integer data Range -263 to 263-1 Storage Size 8 bytes Synonyms INT8 Standards ANSI SQL PostgreSQL BIGINT - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/bigserial?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - BIGSERIAL Versions: PostgreSQL 8.x and 7.x PostgreSQL - BIGSERIAL Syntax BIGSERIAL Data 64-bit auto-increment integer data, NOT NULL constraint is applied, UNIQUE and PRIMARY KEY constraints are not automatically assigned text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/boolean?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - BOOLEAN Versions: PostgreSQL 8.x and 7.x PostgreSQL - BOOLEAN Syntax BOOLEAN Data Boolean data Range TRUE, FALSE (they are PostgreSQL keywords) and NULL. Possible literal values for true state: TRUE, 'true', 't', 'yes', 'y' and '1'. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/bytea?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - BYTEA Versions: PostgreSQL 8.x and 7.x PostgreSQL - BYTEA Syntax BYTEA Data Variable-length binary data Range 231-1 bytes (2G) Standards PostgreSQL Extension PostgreSQL BYTEA - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/char?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - CHAR Versions: PostgreSQL 8.x and 7.x PostgreSQL - CHAR Syntax CHAR[(n)] Data Fixed-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, optional Range text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - DATE Versions: PostgreSQL 8.x and 7.x PostgreSQL - DATE Syntax DATE Data Date data (year, month and day) Range January 01, 4713 BC to December 31, 5874897 Special Values The special values (strings in single quotes) are supported: 'epoch' (1970-01-01 00:00:00 - Unix system time zero), text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/decimal_numeric?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - NUMERIC and DECIMAL Versions: PostgreSQL 8.x and 7.x PostgreSQL - NUMERIC Syntax NUMERIC[(p[,s])] Data Fixed-point numeric data Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/double_precision?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - DOUBLE PRECISION Versions: PostgreSQL 8.x and 7.x PostgreSQL - DOUBLE PRECISION Syntax DOUBLE PRECISION Data Floating-point numeric data Range 1E-307 to 1E+308 Special Values The special case-insensitive values 'NaN' (not-a-number), 'Infinity' and '-Infinity' are allowed text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - FLOAT Versions: PostgreSQL 8.x and 7.x PostgreSQL - FLOAT Syntax FLOAT[(p)] Data Floating-point numeric data Parameters p specifies the precision in binary digits Range 1E-307 to 1E+308, 1 <= p <= 53 Default p is 53 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/int?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - INT Versions: PostgreSQL 8.x and 7.x PostgreSQL - INT Syntax INT Data 32-bit integer data Range -231 to 231-1 (2G) Storage Size 4 bytes Synonyms INTEGER, INT4 Standards ANSI SQL PostgreSQL INT - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/interval?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - INTERVAL Versions: PostgreSQL 8.x and 7.x PostgreSQL - INTERVAL Syntax INTERVAL[(p)] Data Period of time; Interval value is a string in single quotes with the following syntax: '[@] value unit { value unit ... }' text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/money?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - MONEY Versions: PostgreSQL 8.x and 7.x PostgreSQL - MONEY Syntax MONEY Data Monetary data Range -92,233,720,368,547,758.08 to 92,233,720,368,547,758.07 Storage Size 8 bytes Standards PostgreSQL Extension PostgreSQL MONEY - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/real?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - REAL Versions: PostgreSQL 8.x and 7.x PostgreSQL - REAL Syntax REAL Data Floating-point numeric data Range 1E-37 to 1E+37 Special Values The special case-insensitive values 'NaN' (not-a-number), 'Infinity' and '-Infinity' are allowed text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/serial?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - SERIAL Versions: PostgreSQL 8.x and 7.x PostgreSQL - SERIAL Syntax SERIAL Data 32-bit auto-increment integer data, NOT NULL constraint is applied, UNIQUE and PRIMARY KEY constraints are not automatically assigned text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/smallint?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - SMALLINT Versions: PostgreSQL 8.x and 7.x PostgreSQL - SMALLINT Syntax SMALLINT Data 16-bit integer data Range -32768 to 32767 Storage Size 2 bytes Synonyms INT2 Standards ANSI SQL PostgreSQL SMALLINT - Equivalents in Other Databases text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/text?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - TEXT Versions: PostgreSQL 8.x and 7.x PostgreSQL - TEXT Syntax TEXT Data Variable-length character data Range 1G Trailing Spaces Not removed when the value is stored and retrieved. Trailing spaces are significant in comparison. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/time?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - TIME Versions: PostgreSQL 8.x and 7.x PostgreSQL - TIME Syntax TIME[(p)] [WITH|WITHOUT TIMEZONE] Data Time data (hours, minutes, seconds and microseconds) Parameters p is the number of digits in the fractional part of second, 0 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - TIMESTAMP Versions: PostgreSQL 8.x and 7.x PostgreSQL - TIMESTAMP Syntax TIMESTAMP[(p)] [WITH|WITHOUT TIMEZONE] Data Date and time data (year, month, day, hours, minutes, seconds and microseconds) Parameters p is the number of digits in the fractional part of second, 0 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/uuid?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - UUID Versions: PostgreSQL 8.x and 7.x PostgreSQL - UUID Syntax UUID Data Universally unique identifier Version Differences PostgreSQL 8.3 and later - UUID data type is available Storage Size 16 bytes Standards text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/postgresql/data-types/varchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - PostgreSQL Migration Pricing PostgreSQL Data Types - VARCHAR Versions: PostgreSQL 8.x and 7.x PostgreSQL - VARCHAR Syntax VARCHAR[(n)] Data Variable-length character data, single-byte and multibyte character sets Parameters n is the maximum number of characters, optional