Postgres Pro
Downloads
Home   >   mailing lists

Get primary key of a table through SPI - Mailing list pgsql-general

From Oskar Stenberg
Subject Get primary key of a table through SPI
Date
Msg-id HE1PR03MB2971CD233611E2872B44ECC0F9199@HE1PR03MB2971.eurprd03.prod.outlook.com
Whole thread Raw
Responses Re: Get primary key of a table through SPI
List pgsql-general
Tree view
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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PG12: Any drawback of increasing wal_keep_segments
Next
From: Tom Lane
Date:
Subject: Re: Get primary key of a table through SPI