Get primary key of a table through SPI

Поиск
Список
Период
Сортировка
От Oskar Stenberg
Тема Get primary key of a table through SPI
Дата
Msg-id HE1PR03MB2971CD233611E2872B44ECC0F9199@HE1PR03MB2971.eurprd03.prod.outlook.com
обсуждение исходный текст
Ответы Re: Get primary key of a table through SPI  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi!

I need to get the primary keys of a few tables for some code that I'm writing in C. I've found out how to do this through regular SQL code and I know that I can use that SQL code through the SPI. But I was just wondering if there is a better/faster way to get information like this directly through the SPI? I'm imagining something similar to how I can get for example the name of the column with the SPI_fname function? Couldn't find anything when I was looking around, but I might have looked in the wrong place?

Best Regards
Oskar

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: PG12: Any drawback of increasing wal_keep_segments
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Get primary key of a table through SPI