Re: Seeding

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: Seeding
Дата
Msg-id
Pine.LNX.4.44.0207172141500.9047-100000@localhost.localdomain
Ответ на
Re: Seeding (Chad Thompson)
Список
Дерево обсуждения
Re: Seeding "Chad Thompson" <chad@weblinkservices.com>
Chad Thompson writes:

> So if there is an order by in that statement and i want to insert every 2500
> records is that specific?
>
> e.g.
> create table "temp"(
> select distinct(full_phone)
> >from lists
> where client_id =8
> order by full_phone)

That will make the table temporarily ordered, but that will only last
until the next update.

Maybe you want to number your records, and then you can insert the records
you want at the numbers you want (2500, 5000, ...).

-- 
Peter Eisentraut   peter_e@gmx.net

В списке pgsql-novice по дате отправления
От: Rasputin
Дата:
Сообщение: Re: Problems linking to libpq
От: Henshall, Stuart - WCP
Дата:
Сообщение: Re: mirroring databases
FAQ