PostgreSQL

Скачать в pdf «PostgreSQL»


SET TIME ZONE { interval_value_expression | LOCAL }

d.81 SHOW


Name


SHOW — Shows run-time parameters for session SHOW keyword


Inputs


keyword Refer to SET for more information on available variables.


Outputs


NOTICE: variable is value Message returned if successful.


NOTICE: Unrecognized variable value Message returned if variable does not exist. NOTICE: Time zone is unknown If the TZ or PGTZ environment variable is not set.


Description


SHOW will display the current setting of a run-time parameter during a session.


These variables can be set using the SET statement, and can be restored to the default values using the RESET statement. Parameters and values are case-insensitive.


Notes


See also SET and RESET to manipulate variable values.


Usage


Show the current DateStyle setting:


SHOW DateStyle;


NOTICE: DateStyle Is ISO with US (NonEuropean) conventions


Show the current genetic optimizer (geqo) setting:


SHOW GEQO;


NOTICE: GEQO is ON beginning with 11 relations


Compatibility


SQL92


There is no SHOW defined in SQL92.

D.82 TRUNCATE


Name


TRUNCATE — Empty a table TRUNCATE [ TABLE ] name


Inputs


name The name of the table to be truncated.


Outputs


TRUNCATE Message returned if the table is successfully truncated.


Description


TRUNCATE quickly removes all rows from a table. It has the same effect as an unqualified DELETE but since it does not actually scan the table it is faster. This is most effective on large tables.

Скачать в pdf «PostgreSQL»