However you still need to search for their meaning.
Maybe it helps.
Bye
Charles
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Dane Foster Sent: Samstag, 11. Juli 2015 22:56 To: Adrian Klaver Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] A table of magic constants
Hello Adrian,
Thank you for the additional reference links but my concern was less about how to find out what a function (formerly magic constant) that I encountered in the wild did but more about having a list that would educate newcomers/me about what is automatically available for use. For example, in the RLS example from my original message, had I the same or similar need as the poster I would not have been able to formulate the policy that I quoted because I had no clue that SESSION_USER even existed. Specifically I would not have been able to formulate the following clause, "... WITH CHECK (username = SESSION_USER)", w/o first knowing that SESSION_USER was a thing.
As a recent convert to the Church of Postgres I've been consuming vast
Welcome to the One True Faith! :-)
amounts of information on PostgreSQL, and SESSION_USER is not the first nor only, what I'm calling magic constant, that I've seen. Off the top of my head, other examples that I've encountered are CURRENT_USER and CURRENT_TIMESTAMP.
So my question is this, is there a reference table in the documentation that I haven't found yet that lists all magic constants and their meaning? And if not in the official documentation is it in the wiki?
session_user, current_timestamp and current_user are all functions, not magic constants: