Kenneth Evans writes:
> On the other hand the COPY FROM file command has it the other way round - if the separators are semi-colons then the
sourcefile
> London;12;15.7
> Paris;13;22.2
> will work
>
> but
> 'London'; '12'; '15.7'
> 'Paris';'13';'22.2'
> will not!
The COPY input data is a separate data format, so you canno expect quoting
and other features of SQL to work. Read the documentation if you're
curious about details.
> b) My source files for populating the database tables have three header
> lines. It would be convenient if the COPY FROM command had another
> parameter eg "HEADERS n" meaning skip first n lines of input file.
> My current workaround uses a perl pipe but I would prefer a cleaner
> solution.
What's unclean about that?
--
Peter Eisentraut peter_e@gmx.net