Re: COPY form stdin and file

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "senges" <csengstock(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY form stdin and file
Date: 2007-03-05 09:22:22
Message-ID: 10430.1173086542@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"senges" <csengstock(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message lissette 2007-03-05 09:25:46 Postgres ebmail and hermes
Previous Message Richard Huxton 2007-03-05 09:15:05 Re: COPY form stdin and file