On 16 December 2011 10:57, richard terry <rterry(at)internode(dot)on(dot)net> wrote:
> Hope this question isn't too idiotic and makes sense.
> Is there a simple way to increment the value of an integer field in a table in
> sql without reading the fields value adding 1 and re-saving? (the field is not
> a primary key or any other sort of foreign key)
You will either want to create a column with the pseudo type "serial"
or create a sequence and set the default value of an existing integer
column to use that sequence. See the documentation:
In response to
pgsql-novice by date
|Next:||From: Thomas Kellerer||Date: 2011-12-16 11:24:56|
|Subject: Re: question re incrementing an integer field in a table.|
|Previous:||From: richard terry||Date: 2011-12-16 10:57:40|
|Subject: question re incrementing an integer field in a table.|