Hi,
I've just started using PostgreSQL and have been reading up on it.
Part of what I wanted to do was to have a column which automatically
incremented itself by one every time I do an INSERT. From reading the
manual I was lead to believe that the correct type for this was either
serial or
On 18 Nov 2008, at 17:40, Raymond O'Donnell wrote:
On 18/11/2008 17:37, Scott Marlowe wrote:
create table a (i int primary key, info text);
create sequence a_i_seq;
alter table a alter column i set default nextval('a_i_seq');
You'll also need to grant SELECT and UPDATE permissions on the
s
