Re: Backup Schema w/ SQL Text File

On 5/7/06 9:59 PM, "operationsengineer1(at)yahoo(dot)com"
<operationsengineer1(at)yahoo(dot)com> wrote:

> i backed up a db with sql text. no problems.
>
> however, i can't restore sql text using pgadmin3. so
> i go to the commandline and type in...
>
> psql depot_development < create.sql.

Besides the pg_restore functionality to access specific schemas, etc., you
could add tp the beginning of create.sql:

-- Next line assumes no depot_development exists....
create schema depot_development;
set search_path to depot_development, public;

See the documentation for search_path details, but it basically says "unless
I tell you otherwise, use depot_development as the default schema."

Sean