From: Chad Thompson <chad@weblinkservices.com>
To: pgsql-novice <pgsql-novice@postgresql.org>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Seeding
Date: Mon, 15 Jul 2002 12:45:58 -0600
Message-ID: <045701c22c2f$dd8d3860$32021aac@chad> (raw)
Is there any way to automaticly "seed" a number into a list. For example
create table "temp"(
select distinct(full_phone)
from lists
where client_id =8)
This gives me 100,000 unique records
What i would like to do is, every 2500, insert a specific number like '5552552555'
can this be done through sql? or what would be the best approach.
TIA
Chad
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chad@weblinkservices.com, pgsql-novice@postgresql.org
Subject: Re: Seeding
In-Reply-To: <045701c22c2f$dd8d3860$32021aac@chad>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox