2009/8/19 JotaComm <[email protected]>
> Olá, Fernando
>
> Segue um caminho das pedras :)
>
> SELECT relname,substring(adsrc,10,char_length(adsrc)-21) AS
> nome_da_sequencia,currval(substring(adsrc,10,char_length(adsrc)-21)) FROM
> pg_class JOIN pg_attrdef ON pg_class.oid=pg_attrdef.adrelid ORDER BY
> relname;
>
> Agora o resto é com você e falta pouco :)
>
> PS: Fiz na correria, talvez não seja a solução mais adequada.
>
>
Outra colaboração:
postg...@bdteste=# create table foo(codigo serial, nome varchar);
NOTICE: CREATE TABLE will create implicit sequence "foo_codigo_seq" for
serial column "foo.codigo"
CREATE TABLE
postg...@bdteste=# SELECT pg_depend.*,
a.relname,
b.relname
FROM pg_catalog.pg_depend
JOIN pg_catalog.pg_class a on a.oid = pg_depend.objid
JOIN pg_catalog.pg_class b on b.oid = pg_depend.refobjid
where b.relname = 'foo'
and a.relkind = 'S';
classid | objid | objsubid | refclassid | refobjid | refobjsubid |
deptype | relname | relname
---------+------------+----------+------------+------------+-------------+---------+----------------+---------
1259 | 1249802207 | 0 | 1259 | 1249802209 | 1 |
a | foo_codigo_seq | foo
(1 row)
Cordialmente,
--
Fabrízio de Royes Mello
>> Blog sobre PostgreSQL: http://fabriziomello.blogspot.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
