Properties

Name: sequences 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

Name Type Length
  sequence_catalog  sql_identifier  -1 
  sequence_schema  sql_identifier  -1 
  sequence_name  sql_identifier  -1 
  data_type  character_data  -1 
  numeric_precision  cardinal_number  -1 
  numeric_precision_radix  cardinal_number  -1 
  numeric_scale  cardinal_number  -1 
  maximum_value  cardinal_number  -1 
  minimum_value  cardinal_number  -1 
  increment  cardinal_number  -1 
  cycle_option  character_data  -1 
Total: 11 column(s)

SQL


CREATE VIEW sequences AS
    SELECT (current_database())::sql_identifier AS sequence_catalog, (nc.nspname)::sql_identifier AS sequence_schema, (c.relname)::sql_identifier AS sequence_name, ('bigint'::character varying)::character_data AS data_type, (64)::cardinal_number AS numeric_precision, (2)::cardinal_number AS numeric_precision_radix, (0)::cardinal_number AS numeric_scale, (NULL::integer)::cardinal_number AS maximum_value, (NULL::integer)::cardinal_number AS minimum_value, (NULL::integer)::cardinal_number AS "increment", (NULL::character varying)::character_data AS cycle_option FROM pg_namespace nc, pg_class c WHERE ((((c.relnamespace = nc.oid) AND (c.relkind = 'S'::"char")) AND (NOT pg_is_other_temp_schema(nc.oid))) AND ((pg_has_role(c.relowner, 'USAGE'::text) OR has_table_privilege(c.oid, 'SELECT'::text)) OR has_table_privilege(c.oid, 'UPDATE'::text)));


ALTER TABLE information_schema.sequences OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

See Also

List of views