On 11/07/2015 20:07, Dane Foster wrote:
<snip>
> 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:
http://www.postgresql.org/docs/9.4/static/functions-datetime.html
http://www.postgresql.org/docs/9.4/static/functions-info.html
I hope this helps,
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie