Wiki / Configuration Parameters

Sets the display format for interval values. The value sql_standard will produce output matching SQL standard interval literals. The value postgres (which is the default) will produce output matching PostgreSQL releases prior to 8.4 when the DateStyle parameter was set to ISO. The value postgres_verbose will produce output matching PostgreSQL releases prior to 8.4 when the DateStyle parameter was set to non-ISO output. The value iso_8601 will produce output matching the time interval “format with designators” defined in section 4.4.3.2 of ISO 8601. The IntervalStyle parameter also affects the interpretation of ambiguous interval input. See Section 8.5.4 for more information.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

postgres

category

Client Connection Defaults / Locale and Formatting

context

user

documented

true

enumvals

postgres, postgres_verbose, sql_standard, iso_8601

extra desc

Unknown

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

IntervalStyle

short desc

Sets the display format for interval values.

source

pg-settings-source-snapshot

unit

Unknown

vartype

enum