Re: [GENERAL] Does PostgreSQL support a file load function

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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------