| 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: | Whole Thread | Raw Message | 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 |