Re: COPY from stdin;

On May 16, 2005, at 11:40 AM, Peter Schonefeld wrote:

> Hi, I'm curious as to how to get the following snippet from a backup
> file to
> run as a script?
>
> COPY country (id, name) FROM stdin;
> 1 Afghanistan
> 2 Albania
> 3 Algeria
> 4 American Samoa
> 5 Andorra
> 6 Angola
>

Assuming you have tabs there between the values, just put it in a file
and execute it with psql (same way it is used in a backup file).

psql -f thefile database

If you want to have other commands after this in the file, put \. on a
line by itself after the last row:

6 Angola
\.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL