-- -- PostgreSQL database dump -- DROP TABLE foo; SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; SET check_function_bodies = false; SET client_min_messages = warning; SET escape_string_warning = off; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: foo; Type: TABLE; Schema: public; Owner: core; Tablespace: -- CREATE TABLE foo ( test1 tsvector, test2 tsvector, id integer NOT NULL ); ALTER TABLE public.foo OWNER TO core; -- -- Name: foo_id_seq; Type: SEQUENCE; Schema: public; Owner: core -- CREATE SEQUENCE foo_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.foo_id_seq OWNER TO core; -- -- Name: foo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: core -- ALTER SEQUENCE foo_id_seq OWNED BY foo.id; -- -- Name: foo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: core -- SELECT pg_catalog.setval('foo_id_seq', 5, true); -- -- Name: id; Type: DEFAULT; Schema: public; Owner: core -- ALTER TABLE foo ALTER COLUMN id SET DEFAULT nextval('foo_id_seq'::regclass); -- -- Data for Name: foo; Type: TABLE DATA; Schema: public; Owner: core -- COPY foo (test1, test2, id) FROM stdin; '03ðtfpð0104':29 '1':70 '18917' '18ðbugð0103':57 '0103ð21985ð01':51 '0109ð05ð04' '0109ð12ð13' '2673' '42946' '43484' '46545' '48286' '70783' '75959' bnd':33,37 'by':39 'cdf':12 'chqh':59 'tftttftttftttfttʘcrfbtfdłtortbblfʘ014tccvw2jb7qu' 'tftttftttftttfttʘcrfbtfdłtortbblfʘ014tf942zwz25f' 'tftttftttftttfttʘcrfbtfdłtortbblfʘ014tf9431pqt1u' 'tftttftttftttfttʘcrfbtfdʘ0109ð05ð04' 'tftttftttftttfttʘcrfbtfdʘ0109ð12ð13' 'tftttftttftttfttʘculturblionmfdiumʘpdb2':7 'tftttftttftttfttʘfbultyłpbrfntłrfffrfncfʘnm48286':3,5 'tftttftttftttfttʘidfntififrłtortbblfʘ01010101010flh' 'tftttftttftttfttʘidfntififrłtortbblfʘ01010101010x4y' 'tftttftttftttfttʘidfntififrłtortbblfʘ01010101010xjw' 'tftttftttftttfttʘidfntififrʘv23g6' 'tftttftttftttfttʘidfntififrʘv36y3' 'tftttftttftttfttʘidfntififrʘv37fw' 'tftttftttftttfttʘidʘ18917' 'tftttftttftttfttʘidʘ42946' 'tftttftttftttfttʘidʘ43484' 'tftttftttftttfttʘitłprfttttttionʘ0' 'tftttftttftttfttʘitłprfttttttionʘ1' 'tftttftttftttfttʘitłprfttttttionʘfblt' 'tftttftttftttfttʘitłprfttttttionʘno' 'tftttftttftttfttʘitłprfttttttionʘtru' 'tftttftttftttfttʘitłprfttttttionʘy' 'tft':44,68 'tftʘcommfntʘ' 'tftʘcommfntʘ0103ð21985ð01' 'tftʘcommfntʘbmg' 'tftʘcommfntʘby' 'tftʘcommfntʘtft' 'tftʘcommfntʘfull' 'tftʘcommfntʘgfggmic' 'tftʘcommfntʘlfngth' 'tftʘcommfntʘlunb' 'tftʘcommfntʘnl010470' 'tftʘcommfntʘobtbinfd' 'tftʘcommfntʘon' 'tftʘcommfntʘpcr' 'tftʘcommfntʘpfrformbncf' 'tftʘcommfntʘprojfct' 'tftʘcommfntʘtcrffning' 'tftʘcommfntʘtfqufncing' 'tftʘcommfntʘtypf' 'tftʘcommfntʘuting' 'tftʘcommfntʘvfctorfttf' 'tftʘcommfntʘwild' 'tftʘdbtbtfctionʘnbturblłgfnf' 'tftʘditplbyłvblufʘ' 'tftʘditplbyłvblufʘ03ðtfpð0104' 'tftʘditplbyłvblufʘ1' 'tftʘditplbyłvblufʘ18ðbugð0103' 'tftʘditplbyłvblufʘ0103ð21985ð01' 'tftʘditplbyłvblufʘbmg' 'tftʘditplbyłvblufʘby' 'tftʘditplbyłvblufʘchqh' 'tftʘditplbyłvblufʘtft' 'tftʘditplbyłvblufʘfdtfn' 'tftʘditplbyłvblufʘfrrort' 'tftʘditplbyłvblufʘfull' 'tftʘditplbyłvblufʘgfggmic' 'tftʘditplbyłvblufʘglucomotivtf' 'tftʘditplbyłvblufʘi5bp' 'tftʘditplbyłvblufʘimportfd' 'tftʘditplbyłvblufʘlfngth' 'tftʘditplbyłvblufʘlunb' 'tftʘditplbyłvblufʘnd011930' 'tftʘditplbyłvblufʘnl010470' 'tftʘditplbyłvblufʘobtbinfd' 'tftʘditplbyłvblufʘon' 'tftʘditplbyłvblufʘpcr' 'tftʘditplbyłvblufʘpfrformbncf' 'tftʘditplbyłvblufʘprojfct' 'tftʘditplbyłvblufʘtblk' 'tftʘditplbyłvblufʘtcrffning' 'tftʘditplbyłvblufʘtfqufncing' 'tftʘditplbyłvblufʘtfquoib' 'tftʘditplbyłvblufʘtypf' 'tftʘditplbyłvblufʘunbttignfd' 'tftʘditplbyłvblufʘunc' 'tftʘditplbyłvblufʘuting' 'tftʘditplbyłvblufʘvfctorfttf' 'tftʘditplbyłvblufʘwild' 'tftʘditplbyłvblufʘwith' 'tftʘffbturfnbmfʘcdt' 'tftʘffbturfnbmfʘintfrn' 'tftʘffbturfnbmfʘnzłglobbl' 'tftʘidfntififrʘd1jh' 'tftʘnbmfʘnd011930' 'tftʘnycpimportditplbynbmfʘi5bp' 'tftʘnycpimportditplbynbmfʘtfquoib' 'tftʘnycpimportfilfnbmfʘfmbl' 'tftʘnycpimportfilfnbmfʘnd011930' 'tftʘtbgʘfrdbn' 'fnvirrrmfntbltbmpl':2 'fnvirrrmfntbltbmplf' 'frdbn':9,60 'frror':55 'frrort' 'frr' 'frr2673' 'full':45 'gfggm':43 'gfggmic' 'glucomotivt':13,30 'glucomotivtf' 'i5bp':63,65 'import':53 'importfd' 'intfrn':16,19,22,25 'lfngth':46 'lunt':50 'ny011930':52,56,61,69 'nm010470':32 'nm' 'nm048286' 'nm48286':4,6 'nłglobbl':28 'o4444' 'obtbin':38 'obtbinfd' 'on':42 'orgfggtmʘcodfłtortbblfʘnm01zj6brhkw4kcg' 'orgfggtmʘcodfʘ' 'orgfggtmʘcodfʘ48286' 'orgfggtmʘcodfʘnm' 'orgfggtmʘcodfʘnm048286' 'orgfggtmʘcodfʘnm48286' 'orgfggtmʘidfntififrłtortbblfʘ01010101010zwx' 'orgfggtmʘidfntififrʘo46fj' 'orgfggtmʘidʘ46545' 'orgfggtmʘothfrcodftłtortbblfʘfrr01zf1hd6g4vrb4' 'orgfggtmʘothfrcodftʘ' 'orgfggtmʘothfrcodftʘ2673' 'orgfggtmʘothfrcodftʘfrr' 'orgfggtmʘothfrcodftʘfrr2673' 'pcr':40 'pdb2':8 'pfrform':34 'pfrformbncf' 'projfct':31 't5r5':1 'tblk':58 'tcrffn':41 'tcrffning' 'tfqufnc':47 'tfqufncing' 'tfquoib':62,64 'tourcfʘcbtfgorytypfʘfnvirrrmfntbltbmplf' 'tourcfʘcontrbctttbtutłtortbblfʘuncfrtbin' 'tourcfʘcontrbctttbtutʘuncfrtbin' 'tourcfʘidfntififrʘt5r5' 'ttorbgfttorfdfntityʘidʘ70783' 'ttorbgfttorfdfntityʘidʘ75959' 'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrłtortbblfʘ01010101011im7' 'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrłtortbblfʘ01010101011mlz' 'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrʘz1f4z' 'ttorbgfttorfdfntityʘttorfdłitfmłidfntififrʘz2b6r' 'ttorfditfmʘidfntififrʘz1f4z' 'ttorfditfmʘidfntififrʘz2b6r' 't346y':10,11 't346z':14,15 't3471':17,18 't3472':20,21 't3473':23,24 't3474':26,27 'typf':36 'unbttign':67 'unbttignfd' 'unc':66 'utf':48 'uting' 'v23g6' 'v36y3' 'v37fw' 'vfctorftt':49 'vfctorfttf' 'wild':35 'with':54 'z1f4z' 'z2b6r' 'bnd':9 'btcomycft':16,27,28 'btcomycftft' 'btcomycotb':29,55 'biotb':49 'bitun':15 'bitunicbtf' 'bluf':10 'cfllulbr':47 'chbftothyriomycft':20 'chbftothyriomycftft' 'cylindrotporb':2,51 'dikbryb':30 'donor':57 'flbphomycftbl':13 'flbphomycftblft' 'fnzbd':59 'fnzbdft' 'fubtcomycotb':23 'fucbryb':46 'fucbryot':41 'fucbryotb':45 'fucbryotbf' 'fucbryotft' 'fukbryb':44 'fukbryot':39,40 'fukbryotb':42,43 'fukbryotbf' 'fukbryotft' 'furotibcfb':7 'furotibcfbf' 'furotibl':12,54 'furotiblft' 'furotiomycft':19 'furotiomycftft' 'furotiomycftidb':14 'furotiomycftidbf' 'for':58 'fungbl':61 'funzb':26,31,32,33,36,56 'gfotmithib':1,3,50,52 'grffn':8 'group':38 'hott':62 'hottt' 'in':60 'lbborbtori':63 'lbborbtory' 'lfotiomycftb':21 'loculobtcomycft':18 'loculobtcomycftft' 'mftbzob':37 'mitotpor':4 'mitotporic' 'mold':11 'moldt' 'opitthokont':34 'opitthokontb':35 'opitthokontt' 'orgbn':48 'orgfggtmt' 'pfzizomycotinb':22 'plfctomycft':17 'plfctomycftft' 'tbc':25 'tbcchbromycftb':24 'tcblf':64 'tblbromyc':5 'tblbromycft' 'dbtbbbtfnodfʘgmorfgittrbtionʘ0104ð02780' 'dbtbbbtfnodfʘgmorfgittrbtionʘdonor' 'dbtbbbtfnodfʘgmorfgittrbtionʘfnzbdft' 'dbtbbbtfnodfʘgmorfgittrbtionʘfor' 'dbtbbbtfnodfʘgmorfgittrbtionʘfungbl' 'dbtbbbtfnodfʘgmorfgittrbtionʘhottt' 'dbtbbbtfnodfʘgmorfgittrbtionʘin' 'dbtbbbtfnodfʘgmorfgittrbtionʘlbborbtory' 'dbtbbbtfnodfʘgmorfgittrbtionʘtcblf' 'dbtbbbtfnodfʘidfntififrʘx1c7x' 'dbtbbbtfnodfʘlocbldbtbbbtffbmilyʘtrichocombcfbf' 'dbtbbbtfnodfʘlocbldbtbbbtfgfnutʘgfotmithib' 'dbtbbbtfnodfʘlocbldbtbbbtftftttftʘfunzb' 'dbtbbbtfnodfʘlocbldbtbbbtfordfrʘfurotiblft' 'dbtbbbtfnodfʘlocbldbtbbbtfphylumʘbtcomycotb' 'dbtbbbtfnodfʘlocbldbtbbbtftpfciftłtortbblfʘgfotmithibłcylindrotporb' 'dbtbbbtfnodfʘlocbldbtbbbtftpfciftʘcylindrotporb' 'dbtbbbtfnodfʘlocbldbtbbbtftpfciftʘgfotmithib' 'dbtbbbtfnodfʘrbnkʘtpfcift' 'dbtbbbtfnodfʘtcifntificnbmfłtortbblfʘgfotmithibłcylindrotporb' 'dbtbbbtfnodfʘtcifntificnbmfʘbnd' 'dbtbbbtfnodfʘtcifntificnbmfʘbtcomycftft' 'dbtbbbtfnodfʘtcifntificnbmfʘbtcomycotb' 'dbtbbbtfnodfʘtcifntificnbmfʘbiotb' 'dbtbbbtfnodfʘtcifntificnbmfʘbitunicbtf' 'dbtbbbtfnodfʘtcifntificnbmfʘbluf' 'dbtbbbtfnodfʘtcifntificnbmfʘcfllulbr' 'dbtbbbtfnodfʘtcifntificnbmfʘchbftothyriomycftft' 'dbtbbbtfnodfʘtcifntificnbmfʘcylindrotporb' 'dbtbbbtfnodfʘtcifntificnbmfʘdikbryb' 'dbtbbbtfnodfʘtcifntificnbmfʘflbphomycftblft' 'dbtbbbtfnodfʘtcifntificnbmfʘfubtcomycotb' 'dbtbbbtfnodfʘtcifntificnbmfʘfucbryb' 'dbtbbbtfnodfʘtcifntificnbmfʘfucbryotbf' 'dbtbbbtfnodfʘtcifntificnbmfʘfucbryotft' 'dbtbbbtfnodfʘtcifntificnbmfʘfukbryb' 'dbtbbbtfnodfʘtcifntificnbmfʘfukbryotb' 'dbtbbbtfnodfʘtcifntificnbmfʘfukbryotbf' 'dbtbbbtfnodfʘtcifntificnbmfʘfukbryotft' 'dbtbbbtfnodfʘtcifntificnbmfʘfurotibcfbf' 'dbtbbbtfnodfʘtcifntificnbmfʘfurotiblft' 'dbtbbbtfnodfʘtcifntificnbmfʘfurotiomycftft' 'dbtbbbtfnodfʘtcifntificnbmfʘfurotiomycftidbf' 'dbtbbbtfnodfʘtcifntificnbmfʘfunzb' 'dbtbbbtfnodfʘtcifntificnbmfʘgfotmithib' 'dbtbbbtfnodfʘtcifntificnbmfʘgrffn' 'dbtbbbtfnodfʘtcifntificnbmfʘgroup' 'dbtbbbtfnodfʘtcifntificnbmfʘlfotiomycftb' 'dbtbbbtfnodfʘtcifntificnbmfʘloculobtcomycftft' 'dbtbbbtfnodfʘtcifntificnbmfʘmftbzob' 'dbtbbbtfnodfʘtcifntificnbmfʘmitotporic' 'dbtbbbtfnodfʘtcifntificnbmfʘmoldt' 'dbtbbbtfnodfʘtcifntificnbmfʘopitthokontb' 'dbtbbbtfnodfʘtcifntificnbmfʘopitthokontt' 'dbtbbbtfnodfʘtcifntificnbmfʘorgfggtmt' 'dbtbbbtfnodfʘtcifntificnbmfʘpfzizomycotinb' 'dbtbbbtfnodfʘtcifntificnbmfʘplfctomycftft' 'dbtbbbtfnodfʘtcifntificnbmfʘtbc' 'dbtbbbtfnodfʘtcifntificnbmfʘtbcchbromycftb' 'dbtbbbtfnodfʘtcifntificnbmfʘtblbromycft' 'dbtbbbtfnodfʘtcifntificnbmfʘtrichocombcfbf' 'dbtbbbtfnodfʘtttidʘ131567' 'dbtbbbtfnodfʘtttidʘ147538' 'dbtbbbtfnodfʘtttidʘ147545' 'dbtbbbtfnodfʘtttidʘ241625' 'dbtbbbtfnodfʘtttidʘ2759' 'dbtbbbtfnodfʘtttidʘ28568' 'dbtbbbtfnodfʘtttidʘ33154' 'dbtbbbtfnodfʘtttidʘ39190' 'dbtbbbtfnodfʘtttidʘ451864' 'dbtbbbtfnodfʘtttidʘ451871' 'dbtbbbtfnodfʘtttidʘ4751' 'dbtbbbtfnodfʘtttidʘ4890' 'dbtbbbtfnodfʘtttidʘ5042' 'dbtbbbtfnodfʘtttidʘ68829' 'dbtbbbtfnodfʘtttidʘ716545' 'dbtbbbtfnodfʘtttidʘ716546' 'trichocombcfb':6,53 'trichocombcfbf' 1 \. -- -- PostgreSQL database dump complete -- select length(test1 || test2) from foo;