Re: OID Usage - Mailing list pgsql-general

From Bo Lorentsen
Subject Re: OID Usage
Date
Msg-id 41E94A74.8080204@netgroup.dk
Whole thread Raw
In response to Re: OID Usage  (Michael Fuhr <mike@fuhr.org>)
Responses Re: OID Usage
Re: OID Usage
List pgsql-general
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


pgsql-general by date:

Previous
From: Berteun Damman
Date:
Subject: Pgsql taking a *lot* of CPU time (unkillable).
Next
From: Thomas F.O'Connell
Date:
Subject: PL/PgSQL Boolean Comparison Operator Binding