Postgres Pro
Downloads
Home   >   mailing lists

Thread: Does PostgreSQL support a file load function

Does PostgreSQL support a file load function

From
Judy Dilworth
Date:
All:

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?

Additionally, is there any kind of book available on PostreSQL?  I've
heard O'Reilly is working on one but I've haven't seen anything yet.  Is
there anything else out there?

Thanks in advance!!!!

Bob Dilworth
Toledo, Ohio
dilworth@megsinet.net

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

From
Kevin Heflin
Date:
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
--------------------------------------------------------------------