Re: Get primary key of a table through SPI

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oskar Stenberg <oskar_stenberg(at)outlook(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Get primary key of a table through SPI
Date: 2022-03-24 15:59:07
Message-ID: 3016112.1648137547@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Oskar Stenberg <oskar_stenberg(at)outlook(dot)com> writes:
> 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?

SPI doesn't concern itself with such things. If you're writing C code,
there are a lot of server internal APIs you can use for catalog inquiries
--- in this case, RelationGetPrimaryKeyIndex() might be just what you
want. However, you may or may not find those convenient to use, and in
any case they're less stable across major versions than the SPI APIs.
So it's a tradeoff.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zheng Li 2022-03-24 17:54:39 Re: Support logical replication of DDLs
Previous Message Oskar Stenberg 2022-03-24 15:49:39 Get primary key of a table through SPI