Backup Schema w/ SQL Text File

Поиск
Список
Период
Сортировка
От
Тема Backup Schema w/ SQL Text File
Дата
Msg-id 20060508015918.83046.qmail@web33312.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: Backup Schema w/ SQL Text File  (Alan Hodgson <ahodgson@simkin.ca>)
Re: Backup Schema w/ SQL Text File  (Sean Davis <sdavis2@mail.nih.gov>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: postgres db
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: Backup Schema w/ SQL Text File