Implement remaining fields of information_schema.sequences view
Peter Eisentraut <peter_e@gmx.net>
Implement remaining fields of information_schema.sequences view Add new function pg_sequence_parameters that returns a sequence's start, minimum, maximum, increment, and cycle values, and use that in the view. (bug #5662; design suggestion by Tom Lane) Also slightly adjust the view's column order and permissions after review of SQL standard.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/information_schema.sgml | modified | +19 −8 |
| src/backend/catalog/information_schema.sql | modified | +7 −5 |
| src/backend/commands/sequence.c | modified | +51 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +2 −0 |
| src/include/commands/sequence.h | modified | +2 −0 |
| src/test/regress/expected/sequence.out | modified | +7 −0 |
| src/test/regress/sql/sequence.sql | modified | +3 −0 |