| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Bruce Tong <zztong(at)laxmi(dot)ev(dot)net> |
| Cc: | PostgreSQL General <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] CVS Import/Export |
| Date: | 1999-08-18 14:42:58 |
| Message-ID: | Pine.BSF.4.10.9908181142120.55474-100000@thelab.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century
>
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Drabble | 1999-08-18 14:52:39 | Re: [GENERAL] CVS Import/Export |
| Previous Message | Tom Lane | 1999-08-18 14:26:39 | Re: [HACKERS] getting at the actual int4 value of an abstime |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Drabble | 1999-08-18 14:52:39 | Re: [GENERAL] CVS Import/Export |
| Previous Message | Tom Lane | 1999-08-18 14:26:39 | Re: [HACKERS] getting at the actual int4 value of an abstime |