Re: Traversing the catalog using heap_open, systable_beginscan, ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Traversing the catalog using heap_open, systable_beginscan, ...
Дата
Msg-id 20630.1384221794@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Traversing the catalog using heap_open, systable_beginscan, ...  (Mark Crosland <mark.crosland@gmail.com>)
Список pgsql-interfaces
Mark Crosland <mark.crosland@gmail.com> writes:
> Thanks, that helps. I can get table and column info from the catalog now.
> What is the recommended way (structs to access via one of the scan/modify
> callbacks?) to retrieve the column, operation and value, "col", "=" and
> "val" in this example. And is the same method used for both queries and
> updates?
> select * from table where col=val

contrib/postgres_fdw might be a useful example for you.  A lot of this
stuff isn't documented terribly well, you just have to look for some
example code that does what you want to do.
        regards, tom lane



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

Предыдущее
От: Mark Crosland
Дата:
Сообщение: Re: Traversing the catalog using heap_open, systable_beginscan, ...
Следующее
От: "Hoon H."
Дата:
Сообщение: Is it safe to use fundamental type OIDs defined in server/catalog/pg_type.h from client?