Backup Schema w/ SQL Text File

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-novice by date

  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