Re: quicky postgreSQL question

["Oliver Elphick" <olly@lfix.co.uk>]

Shaleh wrote:
  >How can I read in a comma delimited file and have the contents added to a SQ
      >L
  >table?  I seem to recall there being a program that did this for postgres.
 
The command you want is copy (from inside psql).

        COPY [BINARY] class_name [WITH OIDS]
        TO|FROM filename|STDIN|STDOUT [USING DELIMITERS 'delim'];

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Let us therefore come boldly unto the throne of grace,
      that we may obtain mercy, and find grace to help in 
      time of need."             Hebrews 4:16