Chris Gamache <cgg007@yahoo.com> writes:
> I'm planning on dipping my toes into the world of schemata. I have tables,
> created in the Public schema, that I'd like to move to the new schema:
> Is there an easier, faster, less user-error-prone way around this?
pg_dump, edit the "set search_path" commands in the dump script, reload.
regards, tom lane