Re: Problem performing a restore of a data schema in Wi - Mailing list pgsql-general

From Berend Tober
Subject Re: Problem performing a restore of a data schema in Wi
Date
Msg-id 63739.216.238.112.88.1107875120.squirrel@216.238.112.88
Whole thread Raw
In response to Re: Problem performing a restore of a data schema in Wi  (Shaun Clements <ShaunC@relyant.co.za>)
List pgsql-general
> -----Original Message-----
> From: John DeSoi [mailto:desoi@pgedit.com]
> Sent: 07 February 2005 04:21 PM
> To: Shaun Clements
> Cc: 'PgSql General'
> Subject: Re: [GENERAL] Problem performing a restore of a data schema in
> Windows
>
>
>
> On Feb 7, 2005, at 8:22 AM, Shaun Clements wrote:
>
>> psql -U username -d db1 > filename.dm
>

You're going the wrong way. Try either


   psql -U username -d db1 < filename.dm

or

   cat filename.dm | psql -U username -d db1

or

   psql -f filename.dm -U username -d db1




pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Performance tuning using copy
Next
From: "Larry Rosenman"
Date:
Subject: Re: Creating an index-type for LIKE '%value%'