Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: sequences and dependences
- From: Greg Smith <gsmith(at)gregsmith(dot)com>
- To: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: sequences and dependences
- Date: Sat, 24 May 2008 11:08:54 -0400 (EDT)
- Message-id: <Pine(dot)GSO(dot)4(dot)64(dot)0805241105470(dot)563(at)westnet(dot)com>
On Fri, 23 May 2008, Laurent ROCHE wrote:
I would like to write a request where I would get the table name and column name of a sequence. I have been looking at the sytem table and could not link the sequence from pg_class to a table (and even less to a table).
There's an example of how to chain between two pg_class entries using pg_depend that I think is close to what you're looking for at http://wiki.postgresql.org/wiki/Fixing_Sequences
-- * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
- References:
- sequences and dependences
- From: Laurent ROCHE
- sequences and dependences
- Prev by Date: Re: sequences and dependences
- Next by Date: Re: SUMMARY: Solaved. apache perl cgi script cant load libpq.5.dylib on mac os tiger
- Previous by thread: sequences and dependences
- Next by thread: Re: sequences and dependences
- Indexes: