Skip site navigation (1) Skip section navigation (2)

Re: Seeding

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Chad Thompson <chad(at)weblinkservices(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Seeding
Date: 2002-07-17 22:33:07
Message-ID: Pine.LNX.4.44.0207172141500.9047-100000@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-novicepgsql-sql
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(at)gmx(dot)net

In response to

  • Re: Seeding at 2002-07-16 17:31:12 from Chad Thompson

pgsql-novice by date

Next:From: Jim MorcombeDate: 2002-07-18 02:42:06
Subject: Re: Problems linking to libpq
Previous:From: Søren NeigaardDate: 2002-07-17 20:43:42
Subject: How do I only allow one group access to my database

pgsql-sql by date

Next:From: Josh BerkusDate: 2002-07-18 00:19:22
Subject: Re: Indexing UNIONs
Previous:From: Ligia PimentelDate: 2002-07-17 22:27:33
Subject: Re: How to find out if an index is unique?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group