10.4. Listing global sequences

Global sequences may be listed with:

   SELECT *
   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.