possible to run SQL to find places where views are defined?

LabKey Support Forum (Inactive)
possible to run SQL to find places where views are defined? jeckels  2010-09-30 09:25
Status: Closed
 
Hi Ben,

They're in query.customviews. You can run a query like this in pgAdmin to find the ones in the database and the folder they live in:

select cv.name as viewname, queryname, schema, c.name as containername from query.customview cv, core.containers c where cv.container = c.entityid