On Thu, Sep 15, 2005 at 06:48:59PM -0400, Robert Fitzpatrick wrote: > Anyone know a package that can do this? Perferrably a Unix/Linux > package.
It would be trivial to write a script in a language like Perl to read the first line of a file and generate a CREATE TABLE statement from it, then issue a COPY command and send the rest of the file. Determining the columns' data types would be a different matter: if they weren't specified in the header then you'd have to guess or perhaps make them all text.
I've attached a sample implementation of Michael's suggestion.
