Home > mailing lists

Re: Views - Mailing list pgsql-general

From	Raghavendra
Subject	Re: Views
Date	May 9, 2013 12:03:04
Msg-id	CA+h6AhgeRQHgS5yWN-VA2mod6NaazOk5+eouMD2NV5AAVm5G1g@mail.gmail.com Whole thread Raw
In response to	Views (itishree sukla <itishree.sukla@gmail.com>)
List	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

From: sumita
Date: 09 May 2013, 11:28:24
Subject: FATAL: database "a/system_data" does not exist

From: Ian Lawrence Barwick
Date: 09 May 2013, 12:37:44
Subject: Re: Upgrading postgresql from version 7.4.3