On 02/19/2013 02:09 PM, Erik Rijkers wrote: > 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'
Well, I'm not sure about information_schema, but we'll definitely want a pg_matviews system view. Also a \dM. That could wait until 9.4, though. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers