Re: quicky postgreSQL question

[Eric Jacoboni <jaco@titine.fr.eu.org>]

Shaleh <shaleh@livenet.net> writes:

> How can I read in a comma delimited file and have the contents added to a SQL
> table?  I seem to recall there being a program that did this for postgres.

I'm not sure to have understood what you mean, but in psql, you can
issue a "\copy table from file"... file is made of one line per tuple, 
each column is, by default, separated of the next column whith a tab
character. You can change this separator as you want with the \f
command.

Hope this helps.

-- 
-----------------------------------------------------------------------
Éric Jacoboni     « J'ai épuisé le tout-venant, je vais me risquer dans
                    le bizarre » (M. Audiard)
-----------------------------------------------------------------------