Provided by: manpages-zh_1.5.2-1_all bug

NAME

       SET -

SYNOPSIS

       SET [ SESSION | LOCAL ] name { TO | = } { value | 'value' | DEFAULT }
       SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }

DESCRIPTION

       SET  Section 16.4 ``Run-time Configuration''  SET    SET

         SET  SET SESSION   SET  PostgreSQL 7.3   SET   SET

       SET LOCAL   SET  SET LOCAL SET LOCAL   SET

PARAMETERS

       SESSION
                 SESSION  LOCAL

       LOCAL
                COMMIT  ROLLBACK   BEGIN  SET LOCAL

       name
                Section 16.4 ``Run-time Configuration''

       value
                DEFAULT

         Section 16.4 ``Run-time Configuration''   SET

       NAMES  SET NAMES value SET client_encoding TO value

       SEED
                random  0  1  231-1

                setseed

              SELECT setseed(value);

       TIME ZONE
              SET TIME ZONE value for SET timezone TO value   SET TIME ZONE

              'PST8PDT'

              'Portugal'

              'Europe/Rome'

              -7
                      UTC  7  PDT

              INTERVAL '-08:00' HOUR TO MINUTE
                      UTC  8  PST

              LOCAL

              DEFAULT

         Section 8.5 ``Date/Time Types''

NOTES

         set_config   Section 9.13 ``Miscellaneous Functions''

EXAMPLES


       SET search_path TO my_schema, public;

        POSTGRES with ``day before month'' input convention:

       SET datestyle TO postgres, dmy;

          / PostgreSQL

       SET TIME ZONE 'PST8PDT';
       SELECT current_timestamp AS today;

                    today
       -------------------------------
        2003-04-29 15:02:01.218622-07

COMPATIBILITY

       SET TIME ZONE  SQL    PostgreSQL   SET  PostgreSQL

SEE ALSO

       RESET [reset(7)], SHOW [show(l)]

       Postgresql  <laser@pgsqldb.org>