Raphael Araújo e Silva escribió:

> My doubt:  Is there some way to get all sequences attributes at once
> without execute repeatedly SELECT * FROM [sequence_name]?

I don't think there is, yet.

> Also, I'm wondering if there is some way to resolve a sequence OID into
> it's real representation. Let's say that my sequence called "seq_abc" has
> the OID 123456. It's possible to make something like:
> 
> SELECT * FROM 123456::oid or any function that make it's to me!?

Cast it to regclass:
oalvherre=# select 111890::regclass;
   regclass   
--------------
 datos_id_seq
(1 fila)


-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to