dropdb foo;
createdb foo;
psql -e -d foo -c "create table table1(id serial primary key, msg varchar, active boolean);"
psql -e -d foo -c "create table table2(id serial, table1_id integer not null, foreign key (table1_id) references table1(id), msg varchar);"
psql -e -d foo -c "create index idx1_table1_msg_idx on table1(msg);"
psql -e -d foo -c "create index idx2_table2_msg_idx on table2(msg);"
psql -e -d foo -c "create index idx3_table1_active_idx on table1(active);"
psql -e -d foo -c "insert into table1(msg) values ('`date`');"
psql -e -d foo -c "insert into table2(table1_id, msg) select t1.id, '`date`' from table1 t1;"
pg_dump foo
