The variable list : Postgre SQL Command « Postgre SQL « PostgreSQL






The variable list


postgres=#
postgres=# -- The variable list
postgres=#
postgres=# \set
VERSION = 'PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
DBNAME = 'postgres'
USER = 'postgres'
HOST = 'localhost'
PORT = '5432'
ENCODING = 'SQL_ASCII'
LASTOID = '0'
data = 'cat tabledata'
postgres=#
postgres=#
           
       








Related examples in the same category

1.Command can be used to view all sequences in the currently connected database
2.Displays all databases available, with comments
3.Listing psql slash commands
4.Displays all database objects, with comments
5.Displays all database objects in the connected database, with comments
6.Displays all tables in the connected database, with comments
7.Displays all indices in the connected database, with comments
8.Displays all sequences in the connected database, with comments
9.Displays all views in the connected database, with comments
10.Displays all functions in the connected database, with comments
11.Displays all operators in the connected database, with comments
12.Displays all data types in the connected database, with comments
13.To get out of psql
14.timestamp with time zone postmaster start time