On Sun, 28 Feb 1999, Judy Dilworth wrote:
> I'm not yet a PostgreSQL user but I'm seriously considering using it for
> my Linux DB apps. I've been doing some research into it along with msql
> and MySQL. One of the things I haven't been able to find in the on-line
> docs is whether or not PostgreSQL supports some kind of bulk file loader
> utility to populate tables from delimited text files or other types of
> files.
>
> I'd be surprised if such functionality doesn't exit with PostgreSQL so
> I'm assuming that I missed it somewhere in the rather complicated online
> docs available via postgresql.org. Could someone shed some light on
> this for me?
I've imported delimited text files into postgres using the COPY command.
I forget the exact syntax, but it's available in the online user docs, and
I believe once installed 'man copy' will give you some info as well.
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------