Backup Schema w/ SQL Text File - Mailing list pgsql-novice

From
Subject Backup Schema w/ SQL Text File
Date
Msg-id 20060508015918.83046.qmail@web33312.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Backup Schema w/ SQL Text File
Re: Backup Schema w/ SQL Text File
List pgsql-novice
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.

ni dice b/c depot development is a schema of rails,
not a db intself.

what is the synatx to restore, using sql text, a
schema within a db?

i suspect it is something along the lines of:

psql rails[insert correct symbol
here]depot_development < create.sql

i didn't see this addressed in the manual (at least
the main page).

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From:
Date:
Subject: postgres db
Next
From: Alan Hodgson
Date:
Subject: Re: Backup Schema w/ SQL Text File