Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE public.addrobj_fiddle (
    areacode character varying(3),
    autocode character varying(1),
    citycode character varying(3),
    code character varying(17),
    enddate date,
    formalname character varying(120),
    ifnsfl character varying(4),
    ifnsul character varying(4),
    offname character varying(120),
    okato character varying(11),
    oktmo character varying(11),
    placecode character varying(3),
    plaincode character varying(15),
    postalcode character varying(6),
    regioncode character varying(2),
    shortname character varying(10),
    startdate date,
    streetcode character varying(4),
    terrifnsfl character varying(4),
    terrifnsul character varying(4),
    updatedate date,
    ctarcode character varying(3),
    extrcode character varying(4),
    sextcode character varying(3),
    plancode character varying(4),
    cadnum character varying(100),
    divtype numeric(1,0),
    actstatus integer,
    aoguid uuid,
    aoid uuid,
    aolevel integer,
    centstatus integer,
    currstatus integer,
    livestatus integer,
    nextid uuid,
    normdoc uuid,
    operstatus integer,
    parentguid uuid,
    previd uuid
);
--
-- Name: house_fiddle; Type: TABLE; Schema: public; Owner: cpur_user
--

CREATE TABLE public.house_fiddle (
    aoguid character varying(36),
    buildnum character varying(50),
    enddate date,
    eststatus numeric(2,0),
    houseguid character varying(36),
    houseid character varying(36),
    housenum character varying(20),
    statstatus numeric(5,0),
    ifnsfl character varying(4),
    ifnsul character varying(4),
    okato character varying(11),
    oktmo character varying(11),
    postalcode character varying(6),
    startdate date,
    strucnum character varying(50),
    strstatus numeric(1,0),
    terrifnsfl character varying(4),
    terrifnsul character varying(4),
    updatedate date,
    normdoc character varying(36),
    counter numeric(4,0),
    cadnum character varying(100),
    divtype numeric(2,0)
);

-- Data for Name: addrobj_fiddle; Type: TABLE DATA; Schema: public; Owner: cpur_user
--

INSERT INTO public.addrobj_fiddle VALUES ('000', '0', '001', '08000001000031300', '2079-06-06', 'Lincoln', '0816', '0816', 'Lincoln', '85401000000', '85701000001', '000', '080000010000313', '358001', '08', 'str', '1900-01-01', '0313', NULL, NULL, '2020-12-12', '000', '0000', '000', '0000', '', 0, 1, '377ebfdb-e699-48c4-8d38-73b3c824dafb', 'fec485e9-dd68-4271-a4d9-b50deafa176d', 7, 0, 0, 1, NULL, NULL, 1, 'd5bd18b9-22c1-48e2-9b4a-3b7a4c89a3cb', NULL);
INSERT INTO public.addrobj_fiddle VALUES ('000', '0', '001', '0800000100000', '2079-06-06', 'Des Moines', '0816', '0816', 'Des Moines', '85401000000', '85701000001', '000', '08000001000', NULL, '08', 'city', '2020-11-19', '0000', NULL, NULL, '2020-12-12', '000', '0000', '000', '0000', '', 0, 1, 'd5bd18b9-22c1-48e2-9b4a-3b7a4c89a3cb', '6c4e51b2-e197-47b0-afd7-427cb2c96fba', 4, 0, 0, 1, NULL, '798c9e13-a3e3-43d0-a818-ea928a5c4af7', 21, '491cde9d-9d76-4591-ab46-ea93c079e686', '255d98ed-e4e5-434f-85ea-73f9f677e641');
INSERT INTO public.addrobj_fiddle VALUES ('000', '0', '000', '0800000000000', '2079-06-06', 'Iowa', '0800', '0800', 'Iowa State', '85000000000', '85000000', '000', '08000000000', NULL, '08', 'St.', '1900-01-01', '0000', NULL, NULL, '2020-12-12', '000', '0000', '000', '0000', '', 0, 1, '491cde9d-9d76-4591-ab46-ea93c079e686', 'fbeceeb1-a204-459e-b3b0-4de342fabdb0', 1, 0, 0, 1, NULL, NULL, 1, NULL, NULL);

--
-- Data for Name: house_fiddle; Type: TABLE DATA; Schema: public; Owner: cpur_user
--

INSERT INTO public.house_fiddle VALUES ('377ebfdb-e699-48c4-8d38-73b3c824dafb', '', '2020-12-23', 1, 'ae827d5c-7694-4463-9f14-8d25edbf8237', 'ae827d5c-7694-4463-9f14-8d25edbf8237', '11', 0, '0816', '0816', '85401000000', '85701000001', '358001', '2010-12-27', '', 0, '', '', '2020-12-27', 'f4d320f1-6df7-4d53-a259-713af7bed2b0', 50, '', 2);

CREATE TABLE

CREATE TABLE

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

citycode	code	enddate	formalname	ifnsfl	ifnsul	offname	okato	oktmo	plaincode	postalcode	regioncode	shortname	startdate	streetcode	terrifnsfl	terrifnsul	updatedate	actstatus	aoguid	aoid	aolevel	livestatus	nextid	normdoc	operstatus	parentguid	previd
000	0800000000000	2079-06-06	Iowa	0800	0800	Iowa State	85000000000	85000000	08000000000	null	08	St.	1900-01-01	0000	null	null	2020-12-12	1	491cde9d-9d76-4591-ab46-ea93c079e686	fbeceeb1-a204-459e-b3b0-4de342fabdb0	1	1	null	null	1	null	null
001	0800000100000	2079-06-06	Des Moines	0816	0816	Des Moines	85401000000	85701000001	08000001000	null	08	city	2020-11-19	0000	null	null	2020-12-12	1	d5bd18b9-22c1-48e2-9b4a-3b7a4c89a3cb	6c4e51b2-e197-47b0-afd7-427cb2c96fba	4	1	null	798c9e13-a3e3-43d0-a818-ea928a5c4af7	21	491cde9d-9d76-4591-ab46-ea93c079e686	255d98ed-e4e5-434f-85ea-73f9f677e641
001	08000001000031300	2079-06-06	Lincoln	0816	0816	Lincoln	85401000000	85701000001	080000010000313	358001	08	str	1900-01-01	0313	null	null	2020-12-12	1	377ebfdb-e699-48c4-8d38-73b3c824dafb	fec485e9-dd68-4271-a4d9-b50deafa176d	7	1	null	null	1	d5bd18b9-22c1-48e2-9b4a-3b7a4c89a3cb	null

SELECT 3