How to get a configuration value with a SELECT in Postgres

Question

Is there any possibility to get a configuration value with a select in Postgres? For example smthng like this?

SELECT max_locks_per_transaction from config_table

user330315 · Accepted Answer · 2020-05-26 08:40:49Z

2

select current_setting('max_locks_per_transaction');

Or select from pg_settings

select *
from pg_settings
where name = 'max_locks_per_transaction'

answered May 26, 2020 at 8:40

user330315

Sign up to request clarification or add additional context in comments.

Comments

Nick S · Accepted Answer · 2023-08-15 10:18:22Z

1

Even simpler - just use SHOW:

> SHOW max_locks_per_transaction
64

answered Aug 15, 2023 at 10:18

Nick S

1031 silver badge7 bronze badges