Display SQL user session variables

You can display the current user-defined session variables by using the \set command with no arguments. For example:

SALES.MLEE(MLEE)=> \set 
VERSION = 'IBM Netezza SQL Version 1.1'
DBNAME = 'SALES'
USER = 'MLEE'
HOST = '127.0.0.1'
PORT = '5480'
ENCODING = 'LATIN9'
NZ_ENCODING = 'UTF8'
PROMPT1 = '%/%.%s%(%n%)%R%# '
PROMPT2 = '%/%.%s%(%n%)%R%# '
PROMPT3 = '>> '
HISTSIZE = '500'
LASTOID = '0'