Re: Newbie-question

Victor Spång Arthursson <victor@tosti.dk> writes:

> Thanks for the fast answer! There doesn't seem to be any pgadmin for
> OS X, but perhaps it's possible to run in X11… I also tried out the
> phppgadmin, which I found lacking some important features that are
> availible in its counterpart for mysql, the phpmyadmin; for example
> the possibility to set autoincrement on fields.

That's done by declaring the column as type SERIAL in the first
place.  You can add it after the fact by creating a sequence and doing 
ALTER TABEL ALTER COLUMN ADD DEFAULT nextval('myseq')--check the docs
for the exact syntax.  I don't know if phppgadmin lets you modify
defaults easily, but you can always just send the above query
directly...

-Doug