Thread: Re: [GENERAL] Does PostgreSQL support a file load function
Re: [GENERAL] Does PostgreSQL support a file load function
From
kheflin@shreve.net (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 --------------------------------------------------------------------