On Fri, 23 Jan 2004, Joshua D. Drake wrote:
>
> > CREATE DATABASE d;
> > \c d
> >
> > CREATE SCHEMA one;
> > SET search_path TO one;
> >
> > CREATE SEQUENCE foo_seq;
> > CREATE TABLE foo(
> >i integer
> >DEFAULT nextval('foo_seq')
> > );
> >
> >
> > SET search_path TO public;
> >
> >
I must have a fundamental misunderstanding about using schema.
Before using schema, I usually have a file that has my database
definition, and I can play that file back in to a new database to
create a testing area or to create my production setup.
I think I want to use schema the same way.
My pr
