| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Backup Schema w/ SQL Text File |
| Date: | 2006-05-08 01:59:18 |
| Message-ID: | 20060508015918.83046.qmail@web33312.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2006-05-08 04:05:20 | Re: Backup Schema w/ SQL Text File |
| Previous Message | operationsengineer1 | 2006-05-08 01:02:07 | postgres db |