From 39b88432968a2f4c01c20948f12bf9c8e388474d Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 2 Jan 2011 15:08:08 +0200 Subject: 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. --- src/include/commands/sequence.h | 2 ++ 1 file changed, 2 insertions(+) (limited to 'src/include/commands/sequence.h') diff --git a/src/include/commands/sequence.h b/src/include/commands/sequence.h index 932e20351c4..3f3ba529484 100644 --- a/src/include/commands/sequence.h +++ b/src/include/commands/sequence.h @@ -69,6 +69,8 @@ extern Datum setval_oid(PG_FUNCTION_ARGS); extern Datum setval3_oid(PG_FUNCTION_ARGS); extern Datum lastval(PG_FUNCTION_ARGS); +extern Datum pg_sequence_parameters(PG_FUNCTION_ARGS); + extern void DefineSequence(CreateSeqStmt *stmt); extern void AlterSequence(AlterSeqStmt *stmt); extern void ResetSequence(Oid seq_relid); -- cgit v1.2.3