feature suggestion: sequence wizard - Mailing list pgadmin-support

From Bill Eaton
Subject feature suggestion: sequence wizard
Date
Msg-id BHEMIOKCPPFPFJCHEKDCKENBCBAA.ee2@aeroantenna.com
Whole thread Raw
Responses Re: feature suggestion: sequence wizard  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-support
It would be nice to automate the conversion of an integer in a table to a
"serial".

Apparently SQL Server is able to pull this off.

The steps required would be to: * automagically create a new sequence * set default value of the desired field to
nextval(newsequence) * set the value of the sequence to max(field)
 

As far as GUI is concerned, you'd want the user to be able to select the
schema --> table --> field name and the wizard would do the rest.

Best regards,

Bill Eaton, Ph.D.
Senior Engineer
AeroAntenna
mailto://ee2@aeroantenna.com
tel: (818)993-3842





pgadmin-support by date:

Previous
From: "Alessandro @ GMail"
Date:
Subject: weird problem with pgadmin & postgres on debian
Next
From: "Dave Page"
Date:
Subject: Re: Mac version can't dump/restore