This page in other versions: 0.9 / 1.0 / 1.0.3

10.4. Listing global sequences

Global sequences may be listed with:

   FROM pg_class
   INNER JOIN pg_seqam ON (pg_class.relam = pg_seqam.oid)
   WHERE pg_seqam.seqamname = 'bdr' AND relkind = 'S';

When using the psql client provided by BDR PostgreSQL, the sequence access method is also visible in the output of the \ds command.