Sha256: cc7822bd3b25eb9f913017324c502e27186414f0658c212d2870315c68669a48
Contents?: true
Size: 553 Bytes
Versions: 16
Compression:
Stored size: 553 Bytes
Contents
-- Get current sequence value for all sequences
create or replace function getallseqid() returns table(name text, val bigint) as $$
declare
f record;
name varchar(255);
literal varchar(255);
ident varchar(255);
begin
for name in
select relnamespace::regnamespace::text || '.' || relname as name
from pg_class
where (relkind = 'S')
loop
return query execute 'select ' || quote_literal(name) || '::text, last_value from ' || name;
end loop;
return;
end
$$ language 'plpgsql';
Version data entries
16 entries across 16 versions & 1 rubygems