From: | Chadwick Rolfs <c2304182(at)webdevel(dot)urban(dot)csuohio(dot)edu> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Importing data... (fwd) |
Date: | 2001-05-24 17:47:36 |
Message-ID: | Pine.LNX.4.33.0105241346550.19790-100000@webdevel.urban.csuohio.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | harrold | 2001-05-24 18:32:00 | Re: Importing data... (fwd) |
Previous Message | harrold | 2001-05-24 17:18:47 | Re: Importing data... (fwd) |