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

Home
PostgreSQL
1.Aggregate Functions
2.Analytical Functions
3.Array
4.Constraints
5.Cursor
6.Data Type
7.Database
8.Date Timezone
9.Index
10.Inheritance
11.Insert Delete Update
12.Math Functions
13.Postgre SQL
14.Select Query
15.Sequence
16.Store Procedure Function
17.String Functions
18.Subquery
19.Table
20.Table Joins
21.Transaction
22.User Previliege
23.View
PostgreSQL » Postgre SQL » Postgre SQL Command 
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 (GCC3.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
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.