Re: Distinguish view and table problem
От
Filip Rembiałkowski
Тема
Re: Distinguish view and table problem
Дата
Msg-id
92869e660912180847j2a237962sc1163e123c1be78@mail.gmail.com
Ответ на
Distinguish view and table problem (suzhiyang)
Список
Дерево обсуждения
Re: [HACKERS] Distinguish view and table problem "suzhiyang" <suzhiyang@gmail.com>
2009/12/18 suzhiyang <suzhiyang@gmail.com>
pg_class is (quite logically) UNIQUE on (relname, relnamespace)
SELECT c.relkind from pg_class c, pg_namespace n
where c.relnamespace = n.oid
and c.relname = 'thetable'
and n.nspname = 'theschema'
How could I get the relkind of a table(view) by its name from pg_class?
pg_class is (quite logically) UNIQUE on (relname, relnamespace)
SELECT c.relkind from pg_class c, pg_namespace n
where c.relnamespace = n.oid
and c.relname = 'thetable'
and n.nspname = 'theschema'
--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/
В списке pgsql-hackers по дате отправления
