There is a COPY command that you can use...there is a man page for it,
sorry, don't use it myself, so dont know the syntax :( I've never had
much luck with using it, so generally cheat and create a fast perl script
to do it as normal inserts :(
On Wed, 18 Aug 1999, Bruce Tong wrote:
> I feel like such a bone-head asking this question, but I didn't find the
> answer in the FAQ or the documentation, other than pgaccess is supposed to
> have some of this functionality...
>
> How do I import/export comma delimited tables?
>
> I thought a combination of pg_dump and psql might do it, but if so I must
> have missed it. I saw a mention of it for pgaccess, but I'm looking for
> something I can put in a shell script.
>
> --
>
> Bruce Tong | Got me an office; I'm there late at night.
> Systems Programmer | Just send me e-mail, maybe I'll write.
> Electronic Vision / FITNE |
> zztong@laxmi.ev.net | -- Joe Walsh for the 21st Century
>
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org