Re: Views

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: Views
Дата
Msg-id CA+h6AhgeRQHgS5yWN-VA2mod6NaazOk5+eouMD2NV5AAVm5G1g@mail.gmail.com
обсуждение исходный текст
Ответ на Views  (itishree sukla <itishree.sukla@gmail.com>)
Список pgsql-general
Дерево обсуждения




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

В списке pgsql-general по дате отправления: