CREATE SCHEMA POSTGRES_FULL_NN;

CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
CREATE TYPE inventory_item AS (name text, supplier_id integer, price numeric);
SET lc_monetary TO 'en_US.utf8';
SET TIMEZONE TO 'MST';
CREATE EXTENSION hstore;

CREATE TABLE POSTGRES_FULL_NN.TEST_DATASET(id INTEGER PRIMARY KEY, test_column_1 bigint,test_column_10 bytea,test_column_11 char,test_column_12 char(8),test_column_13 character,test_column_14 character(8),test_column_15 text,test_column_16 varchar,test_column_17 character varying(10),test_column_18 cidr,test_column_19 circle,test_column_2 bigserial,test_column_20 date not null default now(),test_column_21 date,test_column_22 float8,test_column_23 float,test_column_24 double precision,test_column_25 inet,test_column_26 int4,test_column_27 int,test_column_28 integer,test_column_29 interval,test_column_3 BIT(1),test_column_30 json,test_column_31 jsonb,test_column_32 line,test_column_33 lseg,test_column_34 macaddr,test_column_35 macaddr8,test_column_36 money,test_column_37 decimal,test_column_38 numeric,test_column_39 path,test_column_4 BIT(3),test_column_40 pg_lsn,test_column_41 point,test_column_42 polygon,test_column_43 float4,test_column_44 real,test_column_45 int2,test_column_46 smallint,test_column_47 serial2,test_column_48 smallserial,test_column_49 serial4,test_column_5 BIT VARYING(5),test_column_51 time without time zone,test_column_52 time,test_column_53 time without time zone not null default now(),test_column_54 timestamp,test_column_55 timestamp without time zone,test_column_56 timestamp without time zone default now(),test_column_57 timestamp,test_column_58 timestamp without time zone,test_column_59 timestamp without time zone not null default now(),test_column_6 BIT VARYING(5),test_column_60 timestamp with time zone,test_column_61 timestamptz,test_column_62 tsquery,test_column_63 tsvector,test_column_64 uuid,test_column_65 xml,test_column_66 mood,test_column_67 tsrange,test_column_68 inventory_item,test_column_69 hstore,test_column_7 bool,test_column_70 time with time zone,test_column_71 timetz,test_column_72 INT2[],test_column_73 INT4[],test_column_74 INT8[],test_column_75 OID[],test_column_76 VARCHAR[],test_column_77 CHAR(1)[],test_column_78 BPCHAR(2)[],test_column_79 TEXT[],test_column_8 boolean,test_column_80 NAME[],test_column_81 NUMERIC[],test_column_82 DECIMAL[],test_column_83 FLOAT4[],test_column_84 FLOAT8[],test_column_85 MONEY[],test_column_86 BOOL[],test_column_87 BIT[],test_column_88 BYTEA[],test_column_89 DATE[],test_column_9 box,test_column_90 TIME(6)[],test_column_91 TIMETZ[],test_column_92 TIMESTAMPTZ[],test_column_93 TIMESTAMP[] );

INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (1, -9223372036854775808, decode('1234', 'hex'), 'a', '{asb123}', 'a', '{asb123}', 'a', 'a', '{asb123}', '192.168.100.128/25', '(5,7),10', 1, '1999-01-08', '1999-01-08', '123', '123', '123', '198.24.10.0/24', 1001, 1001, 1001, 'P1Y2M3DT4H5M6S', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{4,5,6}', '((3,7),(15,18))', '08:00:2b:01:02:03', '08:00:2b:01:02:03:04:05', '999.99', '123', '123', '((3,7),(15,18))', B'101', '7/A25801C8'::pg_lsn, '(3,7)', '((3,7),(15,18))', 3.4145, 3.4145, -32768, -32768, 1, 1, 1, B'101', '13:00:01', '13:00:01', '13:00:01', TIMESTAMP '2004-10-19 10:23:00', TIMESTAMP '2004-10-19 10:23:00', TIMESTAMP '2004-10-19 10:23:00', 'infinity', 'infinity', 'infinity', B'101', TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:00-08', TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:00-08', 'fat & (rat | cat)'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', XMLPARSE (DOCUMENT '<?xml version="1.0"?><book><title>Manual</title><chapter>...</chapter></book>'), 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, true, '13:00:01', '13:00:01', '{1,2,3}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', true, '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((3,7),(15,18))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');
INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (2, 9223372036854775807, '1234', '*', '{asb12}', '*', '{asb12}', 'abc', 'abc', '{asb12}', '192.168/24', '(0,0),0', 9223372036854775807, '1991-02-10 BC', '1991-02-10 BC', '1234567890.1234567', '1234567890.1234567', '1234567890.1234567', '198.24.10.0', -2147483648, -2147483648, -2147483648, '-178000000', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{0,1,0}', '((0,0),(0,0))', '08-00-2b-01-02-04', '08-00-2b-01-02-03-04-06', '1,001.01', '1234567890.1234567', '1234567890.1234567', '((0,0),(0,0))', B'101', '0/0'::pg_lsn, '(0,0)', '((0,0),(0,0))', 3.4145, 3.4145, 32767, 32767, 32767, 32767, 2147483647, B'101', '13:00:02+8', '13:00:02+8', '13:00:02+8', TIMESTAMP '2004-10-19 10:23:54.123456', TIMESTAMP '2004-10-19 10:23:54.123456', TIMESTAMP '2004-10-19 10:23:54.123456', '-infinity', '-infinity', '-infinity', B'101', TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54.123456-08', TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54.123456-08', 'fat:ab & cat'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '', 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, 'yes', '13:00:00+8', '13:00:00+8', '{4,5,6}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', 'yes', '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((0,0),(0,0))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');
INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (3, 0, 'abcd', '*', '{asb12}', '*', '{asb12}', 'Миші йдуть на південь, не питай чому;', 'Миші йдуть на південь, не питай чому;', '{asb12}', '192.168.1', '(-10,-4),10', 0, '1991-02-10 BC', '1991-02-10 BC', '1234567890.1234567', '1234567890.1234567', '1234567890.1234567', '198.10/8', 2147483647, 2147483647, 2147483647, '178000000', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{0,1,0}', '((0,0),(0,0))', '08002b:010205', '08002b:0102030407', '-1,000', '1234567890.1234567', '1234567890.1234567', '((0,0),(0,0))', B'101', '0/0'::pg_lsn, '(999999999999999999999999,0)', '((0,0),(999999999999999999999999,0))', 3.4145, 3.4145, 32767, 32767, 0, 0, 0, B'101', '13:00:03-8', '13:00:03-8', '13:00:03-8', TIMESTAMP '3004-10-19 10:23:54.123456 BC', TIMESTAMP '3004-10-19 10:23:54.123456 BC', TIMESTAMP '3004-10-19 10:23:54.123456 BC', '-infinity', '-infinity', '-infinity', B'101', TIMESTAMP WITH TIME ZONE '3004-10-19 10:23:54.123456-08 BC', TIMESTAMP WITH TIME ZONE '3004-10-19 10:23:54.123456-08 BC', 'fat:ab & cat'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '', 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, '1', '13:00:03-8', '13:00:03-8', '{4,5,6}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', '1', '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((0,0),(0,0))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');
INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (4, 0, '\xabcd', '*', '{asb12}', '*', '{asb12}', '櫻花分店', '櫻花分店', '{asb12}', '128.1', '(-10,-4),10', -9223372036854775808, '1991-02-10 BC', '1991-02-10 BC', '1234567890.1234567', '1234567890.1234567', '1234567890.1234567', '198.10/8', 2147483647, 2147483647, 2147483647, '178000000', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{0,1,0}', '((0,0),(0,0))', '08002b:010205', '08002b:0102030407', '$999.99', '1234567890.1234567', '1234567890.1234567', '((0,0),(0,0))', B'101', '0/0'::pg_lsn, '(999999999999999999999999,0)', '((0,0),(999999999999999999999999,0))', 3.4145, 3.4145, 32767, 32767, -32767, -32767, -2147483647, B'101', '13:00:04Z', '13:00:04Z', '13:00:04Z', TIMESTAMP '0001-01-01 00:00:00.000000', TIMESTAMP '0001-01-01 00:00:00.000000', TIMESTAMP '0001-01-01 00:00:00.000000', '-infinity', '-infinity', '-infinity', B'101', TIMESTAMP WITH TIME ZONE '0001-12-31 16:00:00.000000-08 BC', TIMESTAMP WITH TIME ZONE '0001-12-31 16:00:00.000000-08 BC', 'fat:ab & cat'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '', 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, false, '13:00:04Z', '13:00:04Z', '{4,5,6}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', false, '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((0,0),(0,0))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');
INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (5, 0, '\xabcd', '*', '{asb12}', '*', '{asb12}', '', '', '{asb12}', '2001:4f8:3:ba::/64', '(-10,-4),10', -9223372036854775808, '1991-02-10 BC', '1991-02-10 BC', '1234567890.1234567', '1234567890.1234567', '1234567890.1234567', '198.10/8', 2147483647, 2147483647, 2147483647, '178000000', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{0,1,0}', '((0,0),(0,0))', '08002b:010205', '08002b:0102030407', '$1001.01', '1234567890.1234567', '1234567890.1234567', '((0,0),(0,0))', B'101', '0/0'::pg_lsn, '(999999999999999999999999,0)', '((0,0),(999999999999999999999999,0))', 3.4145, 3.4145, 32767, 32767, -32767, -32767, -2147483647, B'101', '13:00:05.01234Z+8', '13:00:05.01234Z+8', '13:00:05.01234Z+8', TIMESTAMP '0001-12-31 23:59:59.999999 BC', TIMESTAMP '0001-12-31 23:59:59.999999 BC', TIMESTAMP '0001-12-31 23:59:59.999999 BC', '-infinity', '-infinity', '-infinity', B'101', TIMESTAMP WITH TIME ZONE '0001-12-31 15:59:59.999999-08 BC', TIMESTAMP WITH TIME ZONE '0001-12-31 15:59:59.999999-08 BC', 'fat:ab & cat'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '', 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, 'no', '13:00:05.012345Z+8', '13:00:05.012345Z+8', '{4,5,6}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', 'no', '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((0,0),(0,0))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');
INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (6, 0, '\xabcd', '*', '{asb12}', '*', '{asb12}', '\xF0\x9F\x9A\x80', '\xF0\x9F\x9A\x80', '{asb12}', '2001:4f8:3:ba::/64', '(-10,-4),10', -9223372036854775808, '1991-02-10 BC', '1991-02-10 BC', '1234567890.1234567', '1234567890.1234567', '1234567890.1234567', '198.10/8', 2147483647, 2147483647, 2147483647, '178000000', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{0,1,0}', '((0,0),(0,0))', '08002b:010205', '08002b:0102030407', '-$1,000', '1234567890.1234567', '1234567890.1234567', '((0,0),(0,0))', B'101', '0/0'::pg_lsn, '(999999999999999999999999,0)', '((0,0),(999999999999999999999999,0))', 3.4145, 3.4145, 32767, 32767, -32767, -32767, -2147483647, B'101', '13:00:00Z-8', '13:00:00Z-8', '13:00:00Z-8', 'epoch', 'epoch', 'epoch', '-infinity', '-infinity', '-infinity', B'101', TIMESTAMP WITH TIME ZONE '0001-12-31 15:59:59.999999-08 BC', TIMESTAMP WITH TIME ZONE '0001-12-31 15:59:59.999999-08 BC', 'fat:ab & cat'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '', 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, '0', '13:00:06.00000Z-8', '13:00:06.00000Z-8', '{4,5,6}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', '0', '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((0,0),(0,0))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');
INSERT INTO POSTGRES_FULL_NN.TEST_DATASET VALUES (7, 0, '\xabcd', '*', '{asb12}', '*', '{asb12}', '\xF0\x9F\x9A\x80', '\xF0\x9F\x9A\x80', '{asb12}', '2001:4f8:3:ba::/64', '(-10,-4),10', -9223372036854775808, '1991-02-10 BC', '1991-02-10 BC', '1234567890.1234567', '1234567890.1234567', '1234567890.1234567', '198.10/8', 2147483647, 2147483647, 2147483647, '178000000', B'0', '{"a": 10, "b": 15}', '[1, 2, 3]'::jsonb, '{0,1,0}', '((0,0),(0,0))', '08002b:010205', '08002b:0102030407', '-$1,000', '1234567890.1234567', '1234567890.1234567', '((0,0),(0,0))', B'101', '0/0'::pg_lsn, '(999999999999999999999999,0)', '((0,0),(999999999999999999999999,0))', 3.4145, 3.4145, 32767, 32767, -32767, -32767, -2147483647, B'101', '24:00:00', '24:00:00', '24:00:00', 'epoch', 'epoch', 'epoch', '-infinity', '-infinity', '-infinity', B'101', TIMESTAMP WITH TIME ZONE '0001-12-31 15:59:59.999999-08 BC', TIMESTAMP WITH TIME ZONE '0001-12-31 15:59:59.999999-08 BC', 'fat:ab & cat'::tsquery, to_tsvector('The quick brown fox jumped over the lazy dog.'), 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', '', 'happy', '(2010-01-01 14:30, 2010-01-01 15:30)', ROW('fuzzy dice', 42, 1.99), '"paperback" => "243","publisher" => "postgresqltutorial.com",
"language"  => "English","ISBN-13" => "978-1449370000",
"weight"    => "11.2 ounces"'
, '0', '13:00:06.00000Z-8', '13:00:06.00000Z-8', '{4,5,6}', '{-2147483648,2147483646}', '{-9223372036854775808,9223372036854775801}', '{564182,234181}', '{lorem ipsum,dolor sit,amet}', '{l,d,a}', '{l,d,a}', '{someeeeee loooooooooong teeeeext,vvvvvvveeeeeeeeeeeruyyyyyyyyy looooooooooooooooong teeeeeeeeeeeeeeext}', '0', '{object,integer}', '{131070.23,231072.476596593}', '{131070.23,231072.476596593}', '{131070.237689,231072.476596593}', '{131070.237689,231072.476596593}', '{$999.99,$1001.01,45000, $1.001,$800,22222.006, 1001.01}', '{true,yes,1,false,no,0,null}', '{null,1,0}', '{\xA6697E974E6A320F454390BE03F74955E8978F1A6971EA6730542E37B66179BC,\x4B52414B00000000000000000000000000000000000000000000000000000000}', '{1999-01-08,1991-02-10 BC}', '((0,0),(0,0))', '{13:00:01,13:00:02+8,13:00:03-8,13:00:04Z,13:00:05.000000+8,13:00:00Z-8}', '{null,13:00:01,13:00:00+8,13:00:03-8,13:00:04Z,13:00:05.012345Z+8,13:00:06.00000Z-8,13:00}', '{null,2004-10-19 10:23:00-08,2004-10-19 10:23:54.123456-08}', '{null,2004-10-19 10:23:00,2004-10-19 10:23:54.123456,3004-10-19 10:23:54.123456 BC}');