From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | "Peter Schonefeld" <peter(dot)schonefeld(at)bigpond(dot)com> |
Cc: | "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: COPY from stdin; |
Date: | 2005-05-16 17:20:35 |
Message-ID: | 35c04e10f1d86e8883ac52174952271e@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | cbrazvan | 2005-05-16 18:23:07 | Problem with Out-of-resources error? |
Previous Message | Andres Ledesma | 2005-05-16 17:08:32 | Re: concepts? |