On 31 August 2010 18:02, akp geek <akpg...@gmail.com> wrote: > Hi all - > Is there a way I can tell table - sequence dependent information. > which sequences are being used by which table? > thanks for the help
Take a look at the post "Finding orphaned sequences" on this blog: http://blog.tapoueh.org/blog.dim.html Change the last part of the query from "WHERE a.tablename IS NULL" to "WHERE a.tablename IS NOT NULL". That'll show you what tables your SERIAL sequences are being used on. -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
