Re: Importing data... (fwd)

Right, so I just create the empty tables, or put in the primary keys, then
I can use copy?
-- OR is there a way to get postgresql to make the tables
for me according to the CSV file???
That's what I'm really after.

Chadwick Rolfs

On Thu, 24 May 2001 harrold(at)sage(dot)che(dot)pitt(dot)edu wrote:

> On Thu, 24 May 2001, Chadwick Rolfs wrote:
>
> >
> >
> > ---------- Forwarded message ----------
> > Date: Thu, 24 May 2001 12:23:52 -0400 (EDT)
> > From: Chadwick Rolfs <c2304182(at)webdevel(dot)urban(dot)csuohio(dot)edu>
> > To: psql-novice(at)postgresql(dot)org
> > Subject: Importing data...
> >
> > Greetings!! I am trying to get a comma-delimited file to copy into a
> > postgres db. Please help on the best way to do this. I'm not sure on how
> > to create tables from a file like this, so any SQL or psql info will be
> > helpful, thanks..
> >
> >
>
>
> http://www.postgresql.org/idocs/index.php?query-populate.html
>
> i think this is what you are looking for.
>
> --
> john
> Give a man a fish, he owes you one fish.
> Teach a man to fish, you give up your monopoly on fisheries.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>