| From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
|---|---|
| To: | Adam Lang <aalang(at)rutgersinsurance(dot)com> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: imorting csv files into postgres |
| Date: | 2001-01-18 21:55:55 |
| Message-ID: | 3A67666B.423F14CF@wgcr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
Adam Lang wrote:
> Yeah, but he doesn't want to have to create the table before hand, he wants
> postgresql to do all the work. ;)
> The only way that I know of to do that is write a program and feed it the
> CSV file... but in the program it is going to need to create the table.
I have such a script for AOLserver Tcl that does all the work. But it
requires a working AOLserver/PostgreSQL installation, which will take
longer to set up than a simple perl script would take to be written.
The hard part is the CSV parsing -- creating the table and filling in
the data is easy in comparison, especially in the Pg perl interface.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2001-01-18 22:17:26 | Re: [PATCHES] Re: Fixes and enhancements to JDBC driver (take 2) |
| Previous Message | Adam Lang | 2001-01-18 21:33:09 | Re: imorting csv files into postgres |