Re: Re : Re : Resetting SEQUENCEs - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Re : Re : Resetting SEQUENCEs
Date
Msg-id 20071018215416.GD6813@alvh.no-ip.org
Whole thread Raw
In response to Re : Re : Resetting SEQUENCEs  (Laurent ROCHE <laurent_roche@yahoo.com>)
List pgsql-general
Laurent ROCHE wrote:
> Hi,
>
> So nobody can help me to write the SELECT that will return the SEQUENCE names, and their linked columns and their
linkedtables ? 
> Are the system tables documented somewhere ?

Of course -- in the "internals" section.  You need pg_class where
relkind = 's', pg_depend, and possibly pg_attribute.

--
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"La naturaleza, tan frágil, tan expuesta a la muerte... y tan viva"

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Re : Abbreviation list
Next
From: Karsten Hilbert
Date:
Subject: Re: XMIN semantic at peril ?