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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: COPY example for partial tables
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: [SQL] Update timestamp on update