Re: Steps to open or import a data file from Pg 8.1.3? - Mailing list pgsql-novice

From
Subject Re: Steps to open or import a data file from Pg 8.1.3?
Date
Msg-id 20060413212143.33648.qmail@web33303.mail.mud.yahoo.com
Whole thread Raw
In response to Steps to open or import a data file from Pg 8.1.3?  (James.M.Jocius@skf.com)
List pgsql-novice
--- James.M.Jocius@skf.com wrote:

> We have just installed Postgresql 8.1.3 on a Windoze
> PC, but cannot get it
> to open a datafile, "aeroq-data.sql",  that was
> created in Postgresql
> 7.x.x.
> We have never used Postgresql.  What steps should we
> be doing?
>
> TIA for any guidance.

are you using pgadmin3?  as a newbie, that's where'd i
go - and i do go - first.  it should be included with
your install.  if not, google for it, download it and
install it.

right click on your db name, click restore, select
aeroq-data.sql, click "only data" if you only want the
data, and then click ok.

i think that's it.  if it doesn't go well, come back
with the error message.

you may have to use the command line or edit the file
to get it to work, but this is worth a try first.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: James.M.Jocius@skf.com
Date:
Subject: Steps to open or import a data file from Pg 8.1.3?
Next
From: Ennio-Sr
Date:
Subject: Re: Colors/bold chars in a select?