foo.dmp

text/plain

Download

\connect template1
select datdba into table tmp_pg_shadow       from pg_database where datname = 'template1';
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
drop table tmp_pg_shadow;
copy pg_shadow from stdin;
\.
\connect template1 pgtest
create database foo;
\connect foo pgtest
CREATE TABLE b (begt datetime, kid int4);
CREATE TABLE a (kid int4);
COPY b FROM stdin;
Thu Jan 01 00:00:01 1998 CET	1
\.
COPY a FROM stdin;
1
0
\.
CREATE  INDEX b_0 on b using btree ( begt datetime_ops );
CREATE  INDEX b_1 on b using btree ( kid int4_ops );
CREATE  INDEX a_0 on a using btree ( kid int4_ops );