PostgreSQL Data Types
$count++; if($count == 1) { #include "../mobilemenu.php"; } if ($count == 2) { include "../sharemediasubfolder.php"; } ?>
Following are various data types supported by PostgreSQL.
Numeric data types:
NUMERIC, DECIMAL, SMALLINT, INTEGER, BIGINT, FLOAT, REAL, DOUBLE PRECISION
Date and Time types:
DATE, TIMESTAMP, TIME
String types:
VARCHAR, TEXT, CLOB, CHAR
Binary types:
BINARY, VARBINARY, BLOB
JSON Data Type:
cosmos=# CREATE TABLE PLANETJSON(JDATA JSON);
CREATE TABLE
cosmos=# INSERT INTO PLANETJSON VALUES ('{"name": "Earth", "galaxy": "Milky Way"}');
INSERT 0 1
cosmos=# INSERT INTO PLANETJSON VALUES ('{"name": "Jupiter", "galaxy": "Milky Way"}');
INSERT 0 1
cosmos=# SELECT * FROM PLANETJSON;
jdata
--------------------------------------------
{"name": "Earth", "galaxy": "Milky Way"}
{"name": "Jupiter", "galaxy": "Milky Way"}
(2 rows)