Re: OID Usage

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: "pgsql-general postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: OID Usage
Date: 2005-01-15 16:53:08
Message-ID: 41E94A74.8080204@netgroup.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

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