Version: 13.0.1-2

Build #: 32256

Build Date: 2013-May-07 01:07:30 PM

 

Improve Alter Sequence Visual Editor for PostgreSQL 9.2 and below till 8.2

 

1. PostgreSQL 9.2 now has options for Alter Sequence which we need to add to the visual Editor. Below is for PostgreSQL 9.2 and the reference is in http://www.postgresql.org/docs/9.2/static/sql-altersequence.html

 

ALTER SEQUENCE [ IF EXISTS ] name [ INCREMENT [ BY ] increment ]
    [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
    [ START [ WITH ] start ]
    [ RESTART [ [ WITH ] restart ] ]
    [ CACHE cache ] [ [ NO ] CYCLE ]
    [ OWNED BY { table_name.column_name | NONE } ]
ALTER SEQUENCE [ IF EXISTS ] name OWNER TO new_owner
ALTER SEQUENCE [ IF EXISTS ] name RENAME TO new_name
ALTER SEQUENCE [ IF EXISTS ] name SET SCHEMA new_schema