Support Variables

Several variables are defined in POSTGRESQL. These variables are shown in Table . 

 

Table: Common variables

Variable	Meaning
CURRENT_DATE	current date
CURRENT_TIME	current time
CURRENT_TIMESTAMP	current date and time
CURRENT_USER	user connected to the database