Re: COPY example for partial tables
От | Neil Conway |
---|---|
Тема | Re: COPY example for partial tables |
Дата | |
Msg-id | 1129176531.8718.70.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: COPY example for partial tables (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: COPY example for partial tables
Re: COPY example for partial tables |
Список | pgsql-docs |
On Wed, 2005-12-10 at 10:55 -0400, Bruce Momjian wrote: > <para> > + To copy into a file just the countries whose names start with 'A' > + using a temporary table which is automatically deleted: > + </para> > + <programlisting> > + BEGIN; > + CREATE TEMP TABLE a_list_COUNTRIES AS > + SELECT * FROM country WHERE country_name LIKE 'A%'; > + COPY a_list_countries TO '/usr1/proj/bray/sql/a_list_countries.copy'; > + ROLLBACK; > + </programlisting> > + </para> The capitalization of "a_list_countries" is inconsistent -- both references should all be in lowercase, IMO. -Neil
В списке pgsql-docs по дате отправления: