Postgres Pro
Downloads
Home   >   mailing lists

Thread: Views

Views

From
itishree sukla
Date:
Hi all,

Is there any way, i can know what all views are there on a table by a sql query?


Regards,
Itishree

Re: Views

From
Raghavendra
Date:




On Thu, May 9, 2013 at 4:33 PM, itishree sukla <itishree.sukla@gmail.com> wrote:
Hi all,

Is there any way, i can know what all views are there on a table by a sql query?


Regards,
Itishree

Try this...

select table_name,view_name from information_schema.view_table_usage where table_name='table_name';

---
Regards,
Raghavendra
EnterpriseDB Corporation