Problems with \copy and delimiters ','
| От | Bill Moran |
|---|---|
| Тема | Problems with \copy and delimiters ',' |
| Дата | |
| Msg-id | 400834B0.9010001@potentialtech.com обсуждение исходный текст |
| Ответы |
Re: Problems with \copy and delimiters ','
|
| Список | pgsql-general |
I'm having some problems using \copy I have a directory full of test data that I want to be installed automatically when "make database" is issued. While the Makefile rules would seem simple, I'm having some trouble. I want to do this \copy table_name from 'table_name.cdf' delimiters ','; But I get: \copy: parse error at "delimiters" A similar command: copy table_name from '/path/to/file/table_name.cdf' delimiters ','; works fine, but this makes things complicated, as I don't know the path to the files until it happens (who knows where the tarball will be unpacked, I want to give a relative path, not an absolute). The documentation I've found on \copy says to see the docs on copy ;) Does the \copy command not support "delimiters"? This is 7.4 on FreeBSD 5.1. -- Bill Moran Potential Technologies http://www.potentialtech.com
В списке pgsql-general по дате отправления: