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@sage.che.pitt.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@webdevel.urban.csuohio.edu>
> > To: psql-novice@postgresql.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
>