Re: copy from command - quotes and header lines
От | Peter Eisentraut |
---|---|
Тема | Re: copy from command - quotes and header lines |
Дата | |
Msg-id | Pine.LNX.4.44.0211262004010.12428-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | copy from command - quotes and header lines ("Kenneth Evans" <unicorn@unicorn.homechoice.co.uk>) |
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: