Thread

1. Does PostgreSQL support a file load function

   Judy Dilworth <dilworth@megsinet.net> — 1999-02-28T20:01:19Z

   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
   
   
   

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

   Kevin Heflin <kheflin@shreve.net> — 1999-02-28T20:29:53Z

   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
   --------------------------------------------------------------------