Re: COPY form stdin and file - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY form stdin and file
Date
Msg-id 10430.1173086542@sss.pgh.pa.us
Whole thread Raw
In response to COPY form stdin and file  ("senges" <csengstock@gmail.com>)
List pgsql-general
"senges" <csengstock@gmail.com> writes:
> when untaring a pg_dumped tar file the data gets populated like this:

> -----------------
> COPY mytable (id, attr1, attr2) FROM stdin;
> \.
> copy mytable (id, attr1, attr2)  from '$$PATH$$/2387.dat' ;
> -----------------

Not here ... I only see 'FROM stdin' cases.  Please provide a test case,
and mention which PG version you are dealing with.

> The ".\" throws an error within the pgadmin sql query window:
> ERROR:  syntax error at or near "\" at character

You'd need to complain to the pgadmin people about that.

            regards, tom lane

pgsql-general by date:

Previous
From: "senges"
Date:
Subject: COPY form stdin and file
Next
From: Richard Huxton
Date:
Subject: Re: COPY form stdin and file