On 16 December 2011 10:57, richard terry <rterry@internode.on.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)
Hi,
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:
http://www.postgresql.org/docs/current/static/datatype-numeric.html#DATATYPE-SERIAL
Regards
Thom