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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
