Sequences
Sequences in DbWrench can be used to create and track PostreSQL sequences.
Note: Sequences are only reverse engineered form and forward engineered to PostgeSQL servers.
Displaying Sequences Folder
The Sequences folder in Database Explorer is not displayed by default, since most database vendors do not support sequences. To display the Sequences folder:
From the Edit menu select Preferences.
In the Preferences window select Database Explorer.
Ensure that the Show Sequence Folder checkbox is checked.
Forward Engineering Notes
Statements for the creation of sequences may appear in two different sections of forward engineering script. Sequences created automatically with new tables appear just before the table creation statements. Sequences created independent of any table will appear near the end of the script.
Sequences that exist on the server can not be updated using DbWrench. DbWrench will only update sequence comments.
See also: