Re: Backup Schema w/ SQL Text File

On 5/7/06 9:59 PM, "operationsengineer1@yahoo.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