drop table if exists simple;
create table simple (
id serial primary key,
t text, v varchar(128), cf char(128), bp bpchar, ss smallserial, bs bigserial,
b bool, c char, i2 int2, i4 int4, o oid, i8 int8, ib numeric(100, 100), m money, f4 float4, f8 float8,
d date, tm time, tmz time with time zone, ts timestamp, tz timestamp with time zone, iv interval,
u uuid, j json, x xml,
bf bit(4), bt varbit, cd cidr, it inet, ma macaddr,
p point, pg polygon, bx box, cr circle, ph path,
tq tsquery, tv tsvector
);
insert into simple (
t, v, cf, bp, ss, bs,
b, c, i2, i4, o, i8, ib, m, f4, f8,
d, tm, tmz, ts, tz, iv,
u, j, x, bf, bt, cd, it, ma,
p, pg, bx, cr, ph,
tq, tv
) values (
'text', 'varchar', 'chars', 'padded', 0, 0,
true, 'x', 2, 4, 0, 8, 0, 19.99, 0.4, 0.8,
'2000-01-01', '04:00:00', '06:00:00', '2000-01-01 00:00:01', '2000-02-02 00:00:02', '1 hour',
'00000000-0000-0000-0000-000000000000', '{}'::json, '<a><b/></a>', '0101', '01010101', '192.168/24', '192.168.0.1', '08:00:2b:01:02:03',
'(1, 1)', '((0, 0), (1, 1), (2, 2))', '((0, 0), (1, 1))', '((0, 0), 1)', '((0, 0), (1, 1), (2, 2))',
'foo & bar', 'foo bar baz'
);