how do I get the table name from a query?

Поиск
Список
Период
Сортировка
От Reggie Burnett
Тема how do I get the table name from a query?
Дата
Msg-id 00b001c2c610$ae084870$c600a8c0@endeavor
обсуждение
Ответы Re: how do I get the table name from a query?
Список pgsql-hackers

When using the FE/BE, how do I retrieve the table name for a given column?  Say I had the following SQL:

 

Select c.id, c.name, d.phone from Members c, Addresses d where c.id < 200

 

From the docs of the FE/BE, I would see that the fields are named id, name, phone but how do I find out the source tables that each field came from?  I need to know this to discover nullability of fields, uniqueness, etc.

 

Thanks

Reggie

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