Re: [HACKERS] Q: pg_catalog views, OIDs and search_path

2003-02-17 Thread Tom Lane
Ian Barwick <[EMAIL PROTECTED]> writes: > Q: is there any likelihood of the pg_catalog views (pg_views, pg_tables, >pg_indexes, pg_rules, possibly others I have missed) returning the >relevant OID or (probably cleaner) the result of pg_table_is_visible() >as a boolean? That strikes m

[HACKERS] Q: pg_catalog views, OIDs and search_path

2003-02-17 Thread Ian Barwick
I'm preparing a patch to make more psql slash commands tab-completable (\di, \dv etc-) and have come across the following dilemma: - only relations visible in the current search path should be returned [*] - to determine visibilty via pg_catalog.pg_table_is_visible(), the relation's OID is nec