Re: update entire table (with PostGreSQL alone)? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: update entire table (with PostGreSQL alone)?
Date
Msg-id 20030827123020.GA25066@wolff.to
Whole thread Raw
In response to update entire table (with PostGreSQL alone)?  ("yruhn" <yruhn@xdh.nl>)
List pgsql-general
On Fri, Aug 22, 2003 at 10:48:39 +0200,
  yruhn <yruhn@xdh.nl> wrote:
> Dear anyone,
>
> So, I wish to:
> 1- update every data point in the table (based on the UNIQUE column 'a' (=PRIMARY KEY)), and if this value of a is
notpresent (such as for instance value 9: 9,0,0),I wish to; 
> 2- insert a new row with data points
> 3- and I want to delete old rows that are not used present in the new table (such as row 7 : 7,8,9)
>
> How can I update an entire table with just using (PestGre)SQL?

Use INSERT and DELETE queries. To get a more specific answer you
need to state what you want to do more precisely.

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Weird psql problem
Next
From: Ron Johnson
Date:
Subject: Re: SQL Command - To List Tables ?