Re: Materialized views WIP patch - Mailing list pgsql-hackers

On Sat, February 16, 2013 02:01, Kevin Grittner wrote:
> matview-v4.patch.gz

Hi,

I was wondering if material views should not go into information_schema.  I was thinking either
.views or .tables.  Have you considered this?

I ask because as far as I can see querying for mv's has to go like this:

SELECT n.nspname, c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('m','')
  and n.nspname = 'myschema'

which seems rather ugly.


Also, some documentation typos: please see attached.


Thanks,

Erik Rijkers