Re: COPY form stdin and file

[Richard Huxton <dev@xxxxxxxxxxxx>]

senges wrote:
> Hi all,
> 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' ;
> -----------------
>
> where $$PATH$$ gets replaced by the current path.
>
> Anyone knows whats the aim of this ?
> The ".\" throws an error within the pgadmin sql query window:
> ERROR:  syntax error at or near "\" at character

The "\." on a separate line ends the COPY ... FROM stdin above it.

I'm not sure pgadmin has a "stdin" to process data from though.

pg_restore is probably the tool you want to use.

--
  Richard Huxton
  Archonet Ltd