From: | "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Unload of Data |
Date: | 2000-12-12 17:21:58 |
Message-ID: | 20001212182158.A5244@frithjof |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, Dec 07, 2000 at 09:31:59AM +1300, brentr(at)hdc(dot)govt(dot)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(at)tph(dot)tuwien(dot)ac(dot)at>
Deutsch * English * Esperanto * Latine
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-12 17:57:46 | Re: processing results from INTERSECT, UNION or EXCEPT |
Previous Message | Chr. Rossmanith | 2000-12-12 16:33:03 | foreign keys & pg_dump |