Re: end of COPY
| От | Ron Johnson |
|---|---|
| Тема | Re: end of COPY |
| Дата | |
| Msg-id | CANzqJaCW48poyRujU_vzdO1UwbhqHyXiWgt1sRtLxpWKc5W++A@mail.gmail.com обсуждение исходный текст |
| Ответ на | end of COPY (Marc Millas <marc.millas@mokadb.com>) |
| Список | pgsql-general |
On Wed, Mar 5, 2025 at 10:22 AM Marc Millas <marc.millas@mokadb.com> wrote:
Hi,on a Postgres 16 DB running on a redhat 8.5 x86 machineI want to input some data using copy from stdinso.. more that 700 000 lines goes well.Then the flow contains a single line: \.to my understanding this means end of the copy
I just tested this on PG 16.8. No backslash.
$ psql TAP -Xc "copy public.job_notification TO STDOUT;"
"End of data can be represented by a single line containing just backslash-period (
\.).""the end-of-data marker (
\.) or the null string (\N by default)."but, Postgres generates an error :invalid input syntax for type numeric "\."then the 2 lines stating the copy command that was executed.what am I missing ?
COPY is expecting something after the backslash.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-general по дате отправления: