<entry></entry>

<entry>The last sequence value written to disk. If caching is used,

this value can be greater than the last value handed out from the

sequence. Null if the sequence has not been read from yet.</entry>

sequence. Null if the sequence has not been read from yet. Also, if

the current user does not have <literal>USAGE</literal>

or <literal>SELECT</literal> privilege on the sequence, the value is

null.</entry>

</row>

</tbody>

</tgroup>

S.seqincrementAS increment_by,

S.seqcycleAS cycle,

S.seqcacheAS cache_size,

pg_sequence_last_value(C.oid)AS last_value

CASE

WHEN has_sequence_privilege(C.oid,'SELECT,USAGE'::text)

THEN pg_sequence_last_value(C.oid)

ELSENULL

ENDAS last_value

FROM pg_sequence SJOIN pg_class CON (C.oid=S.seqrelid)

LEFT JOIN pg_namespace NON (N.oid=C.relnamespace)

WHERE NOT pg_is_other_temp_schema(N.oid)

s.seqincrement AS increment_by,

s.seqcycle AS cycle,

s.seqcache AS cache_size,

pg_sequence_last_value((c.oid)::regclass) AS last_value

CASE

WHEN has_sequence_privilege(c.oid, 'SELECT,USAGE'::text) THEN pg_sequence_last_value((c.oid)::regclass)

ELSE NULL::bigint

END AS last_value

FROM ((pg_sequence s

JOIN pg_class c ON ((c.oid = s.seqrelid)))

LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))