#!/bin/sh

createdb foodb
createuser foouser1
createuser foouser2

psql foodb <<_EOF_
grant execute on function lo_import(text) to foouser1;
_EOF_

psql -U foouser1 foodb <<_EOF_
create table foo (col oid);
insert into foo select lo_import('/dev/null') from generate_series(1,1000000);
_EOF_