Re: OID Usage

Michael Fuhr wrote:

>Here's a first attempt at a view that shows tables and their primary
>key columns and sequences.  I chose a view instead of a function
>because a view shows everything in the database with a single query,
>which simplifies visual examination of the results.  Modify it or
>convert it to a function as needed.
>
>
This is just what I need to avoid to much headaches regarding PG system
tables, and it works on all my tables, as expected.

>The view assumes single-column primary keys defined as SERIAL types.
>
>
is this the "c2.relkind = 'S'" in the view ?

This seem to be what I need to convert my function to be a oid free version, many thanks.

/BL