Re: Unload of Data - Mailing list pgsql-novice

From Albert REINER
Subject Re: Unload of Data
Date
Msg-id 20001212182158.A5244@frithjof
Whole thread Raw
In response to Unload of Data  (brentr@hdc.govt.nz)
List pgsql-novice
On Thu, Dec 07, 2000 at 09:31:59AM +1300, brentr@hdc.govt.nz wrote:
> Hi
>
> How can I unload a small subset of data from a table ie
>
>  select * from rates
>  where propid = '12345'
>
> 1 Record of around 30000.

Is this what you want?

delete from rates where propid='12345'


HTH,

Albert.



--

--------------------------------------------------------------------------
Albert Reiner                                   <areiner@tph.tuwien.ac.at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------

pgsql-novice by date:

Previous
From: Christophe Devine
Date:
Subject: check_primary_key on Postgres 6.5.3-23
Next
From: Sterling
Date:
Subject: Re: Creating Log file - run in background.