Search code examples
databasepostgresqlvariablesparameterspsql

How to list all parameters in Postgres?

I was wondering if there's a parameter for the currently authenticated psql user?

But then I wonder a more broader question - how can I just see what all the paremeters are? I might discover some interesting parameters if I could see a whole list of them?

I'm only seeing online how to get the value of one parameter. Not a list...

Solution

  • PostgreSQL does not have such a thing as server-side session variables, so it's not clear what you are asking about.

    Some PLs (such as PL/Python, PL/Perl) have session variables (%_SHARED in PL/Perl, GD and SD in PL/Python for example), but they are internal to the PL, not part of the server proper.

    psql also has variables, which you can set with \set, and you can get a list with the same command. I suppose that's not what you want though.

    Maybe you refer to so-called custom GUC configuration parameters, which are sometimes abused as session variables. You can get a list of those using SHOW ALL or SELECT * FROM pg_catalog.pg_settings.