Re: catalog info for sequences

Marc Munro wrote:
> Can someone please tell me how to extract the mix, max, increment by,
> etc, values for a sequence from the system catalogs.  Is this in the
> manual somewhere (I couldn't find it)?
>
> Thanks
>
> __
> Marc
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
try with select * from your_sequence_name;

or try next plpgsql function:


CREATE OR REPLACE FUNCTION obtenersecuencias() RETURNS void AS $$
DECLARE
    sec_names RECORD;
    row RECORD;
    secuencia refcursor;
BEGIN
    FOR sec_names IN select relname from pg_class where relkind = 'S' LOOP
        OPEN secuencia FOR EXECUTE 'SELECT * FROM ' || sec_names.relname;
        FETCH secuencia INTO row;
        CLOSE secuencia;

        RAISE NOTICE 'secuencia = %, last_val = %',row.sequence_name,
row.last_value;

    END LOOP;

END;
$$ LANGUAGE plpgsql;

--
Regards,

Julio Cesar Sánchez González.

--
Ahora me he convertido en la muerte, destructora de mundos.
Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.

www.sistemasyconectividad.com.mx        http://darkavngr.blogspot.com/