Re: COPY example for partial tables
От | Bruce Momjian |
---|---|
Тема | Re: COPY example for partial tables |
Дата | |
Msg-id | 200510131445.j9DEj9605226@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: COPY example for partial tables (Neil Conway <neilc@samurai.com>) |
Список | pgsql-docs |
Neil Conway wrote: > 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. > Fixed. Thanks. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-docs по дате отправления: