The variable list : Postgre SQL Command « Postgre SQL « PostgreSQL
- 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 (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 | | |