Is it possible to set end-of-data marker for COPY statement.
| От | Junfeng Yang |
|---|---|
| Тема | Is it possible to set end-of-data marker for COPY statement. |
| Дата | |
| Msg-id | DM5PR0501MB3880CB81067E14F9C78FA28BCC2E0@DM5PR0501MB3880.namprd05.prod.outlook.com обсуждение исходный текст |
| Ответы |
Re: Is it possible to set end-of-data marker for COPY statement.
Re: Is it possible to set end-of-data marker for COPY statement. |
| Список | pgsql-hackers |
Hi hackers,
As described in the doc https://www.postgresql.org/docs/current/sql-copy.html, the TEXT format recognizes
backslash-period (\.) as end-of-data marker.
The example below will raise an error for the line contains `\.`.
CREATE TABLE test (
id int,
name text,
dep text
) Data in file "/tmp/data".
122,as\.d,adad
133,sa dad,adadadcopy test from '/tmp/data' DELIMITER ','; This requires users to escape the end-of-data marker manually in their data.
Why we don't have a mechanism to define other characters as end-of-data marker?
Or there are other ways to avoid escape the end-of-data in data?
Regards,
Junfeng
В списке pgsql-hackers по дате отправления: