Re: Problem performing a restore of a data schema in Wi

From: "Berend Tober" <btober(at)seaworthysys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem performing a restore of a data schema in Wi
Date: 2005-02-08 15:05:20
Message-ID: 63739.216.238.112.88.1107875120.squirrel@216.238.112.88
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: John DeSoi [mailto:desoi(at)pgedit(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2005-02-08 15:11:21 Re: Creating an index-type for LIKE '%value%'
Previous Message Martijn van Oosterhout 2005-02-08 14:35:07 Re: Performance tuning using copy