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

Re: Unload of Data

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 (view raw or flat)
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
--------------------------------------------------------------------------

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2000-12-12 17:57:46
Subject: Re: processing results from INTERSECT, UNION or EXCEPT
Previous:From: Chr. RossmanithDate: 2000-12-12 16:33:03
Subject: foreign keys & pg_dump

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