sl_seqlastvalue
Structure of sl_seqlastvalue
seq_idinteger
seq_setinteger
seq_reloidoid
seq_origininteger
seq_last_valuebigint
Figure 8-1. Definition of view sl_seqlastvalue
SELECT sq.seq_id
, sq.seq_set
, sq.seq_reloid
, s.set_origin AS seq_origin
, sequencelastvalue
(
(
(quote_ident
(
(pgn.nspname)::text
) || '.'::text
) || quote_ident
(
(pgc.relname)::text
)
)
) AS seq_last_value
FROM sl_sequence sq
, sl_set s
, pg_class pgc
, pg_namespace pgn
WHERE (
(
(s.set_id = sq.seq_set)
AND (pgc.oid = sq.seq_reloid)
)
AND (pgn.oid = pgc.relnamespace)
); |