Re : Re : Re : [GENERAL] Resetting SEQUENCEs

2007-10-19 Thread Laurent ROCHE
age d'origine De : Alvaro Herrera <[EMAIL PROTECTED]> À : Laurent ROCHE <[EMAIL PROTECTED]> Cc : Martijn van Oosterhout <[EMAIL PROTECTED]>; pgsql-general@postgresql.org Envoyé le : Jeudi, 18 Octobre 2007, 23h54mn 16s Objet : Re: Re : Re : [GENERAL] Resetting SEQUENCEs L

Re: Re : Re : [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Alvaro Herrera
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 linked tables ? > Are the system tables documented somewhere ? Of course -- in the "internals" section. You need pg_class where relkind = 's', pg_de

Re : Re : [GENERAL] Resetting SEQUENCEs

2007-10-18 Thread Laurent ROCHE
Hi, So nobody can help me to write the SELECT that will return the SEQUENCE names, and their linked columns and their linked tables ? Are the system tables documented somewhere ? Cheers, [EMAIL PROTECTED] The Computing Froggy - Message d'origine De : Laurent ROCHE <[EMAIL PROTECTED]>