Re: Asia/Jakarta Timezone problem

"postgresql_2016@163.com" <postgresql_2016@163.com> writes:
> 3.  Create table, insert timestamp data with WIB or WIT,* failed*.

WIB and WIT aren't in the default list of known timezone abbreviations,
but you can add them in a particular installation easily enough.  See

https://www.postgresql.org/docs/10/static/datetime-config-files.html

You could copy the definitions appearing in Asia.txt:

WIB     25200    # Waktu Indonesia Barat
                 #     (Asia/Jakarta)
                 #     (Asia/Pontianak)
WIT     32400    # Waktu Indonesia Timur (caution: this used to mean 25200)
                 #     (Asia/Jayapura)
WITA    28800    # Waktu Indonesia Tengah
                 #     (Asia/Makassar)

Note that which abbreviations are accepted for input has nothing to
do with what you've set "timezone" to.

            regards, tom lane