Alterando TimeZone PostgreSQL
Posted on: August 19, 2022 09:51 PM
Posted by: Renato
Categories: postgresql database db dba
Views: 3218
Alterando TimeZone PostgreSQL - America/Sao_Paulo -03
select current_timestamp;
select * from pg_timezone_names;
SHOW timezone ;
set TimeZone='America/Sao_Paulo';
SELECT pg_reload_conf();
SHOW timezone ;
set TimeZone='America/Sao_Paulo';
SELECT pg_reload_conf();
4
Donate to Site

About Author
Renato
Developer
Add a Comment
Comments 0 Comments
No comments yet! Be the first to comment
Blog Search
Categories
100DaysOfCode (9)
adb (1)
agi (1)
akitando (1)
algoritimo (1)
altadisponibilidade (1)
android (2)
angular (3)
angularjs (4)
apache (4)
api (5)
API_KEY_GOOGLE_MAPS (1)
aplicativo (1)
apple (1)
AppSec (1)
Architecture (4)
ArchLinux (1)
arquitetura (3)
artigo (2)
athena (1)
autenticacao (2)
auth (1)
auth (1)
authentication (4)
authorization (3)
autorizacao (2)
aws (14)
Axios (1)
backend (13)
backup (1)
banco (1)
bancodedados (2)
bash (3)
BigLinux (2)
binaural (1)
biologia (1)
Black Hat (3)
blade (3)
bolsonaro (1)
boot (1)
brain (1)
Brasil (1)
bug (1)
c4 (1)
c4-models (1)
cache (1)
cavalotroia (1)
certbot (1)
chatgpt (1)
ciencia (6)
cinnamon (1)
ckeditor (1)
CMS (2)
collections (1)
colors (2)
combustivel (2)
community (1)
compactar (1)
composer (1)
compression (1)
containers (3)
controllers (0)
cor (1)
covid19 (1)
cqrs (1)
cron (2)
csv (1)
Curisidades (1)
data (1)
database (42)
db (3)
dba (18)
ddd (3)
debian (12)
Deepin (1)
dev (12)
developer (37)
devops (25)
DevSecOps (4)
Diagramas (1)
Dicas (45)
Docker (28)
documentation (1)
dracula (1)
dropbox (1)
ec2 (1)
ecommerce (1)
economia (1)
educacao (1)
Elasticsearch (1)
ElonMusk (2)
eloquent (14)
Error (1)
escopos (1)
eventdrive (1)
faceapp (1)
federal (1)
fedora (2)
Fetch (1)
ffaa (1)
ffmpeg (2)
Fibonacci (1)
Filament (1)
firefox (1)
flow (1)
flutter (1)
forcas armadas (1)
front-end (29)
gasolina (1)
git (9)
github (5)
gitlab (3)
GitOps (1)
gnome (2)
google (4)
gource (2)
governancadedados (1)
gpt (1)
Grunt (1)
guard (1)
hardware (3)
haru (1)
historia (1)
homeOffice (2)
host (1)
hotfix (1)
htm (1)
html (2)
http (1)
ia (1)
ibm (1)
idiomas (1)
imagick (2)
intel (3)
inteligencia-artificial (3)
inteligenciadedados (4)
iode (1)
iot (1)
JasperReports (1)
java (1)
javascript (7)
jenkins (4)
jobs (3)
JQuery (1)
js (1)
json (2)
jwt (5)
k8s (1)
kali-linux (1)
kitematic (1)
kube (2)
KubeCon (1)
Kubernetes (3)
l2tp (1)
laptop (2)
Laravel (173)
LaravelFilament (1)
laraveloctane (1)
laravelphp (10)
lets-encrypt (3)
LETSENCRYPT (1)
lider (1)
linkedin (1)
linux (118)
linux-tools (6)
liquid (1)
livros (2)
llama (1)
log (1)
lucena (1)
lumen (1)
mac (2)
macos (2)
macox (4)
magento (2)
Manjaro (1)
maps (1)
mariadb (4)
markdown (1)
matematica (1)
MeioAmbiente (1)
memcached (1)
messaging (1)
microg (1)
microservice (1)
microservices (2)
Migration (1)
militar (1)
modelagemdedados (1)
models (1)
mongodb (4)
Monitor (1)
monitoring (2)
Monolith (1)
Mozilla (1)
multiple_authen (2)
mysql (31)
mysqli (3)
networking (1)
nginx (9)
NoCookies (1)
node (7)
nodejs (5)
nosql (1)
noticias (2)
npm (3)
nuance (1)
nuxt (1)
nvidia (1)
nvm (1)
Oauth2 (2)
Observability (1)
octane (1)
October (1)
odd (1)
Oh My Zsh (1)
OOD (0)
openai (3)
opensource (3)
optimization (1)
oracle (1)
orm (1)
OUTROS (17)
Padrao de design (4)
Passport (2)
Passwordless (1)
payment (1)
paypal (1)
pendrive (1)
performance (3)
PHP (133)
PHP Swoole (5)
phpfpm (1)
phpjasper (1)
phpswoole (1)
phpunit (2)
piada (1)
picpay (1)
pipelines (1)
PKCE (1)
podcast (1)
policia (2)
politica (2)
POO (2)
postgresql (42)
presenter (1)
prf (1)
privacidade (1)
programming (22)
Python (1)
pytorch (1)
query (4)
queue (1)
RabbitMQ (3)
rancher (1)
Raspberry (4)
react (7)
reactjs (8)
reactnative (5)
redis (2)
replication (1)
repmgr (1)
rest (5)
restfull (1)
rpi (1)
ruby (1)
rust (1)
RustLang (1)
s3 (4)
sail (3)
Samurai (1)
saude (1)
scheduling (1)
script (3)
security (2)
seguranca (2)
servers (4)
services (1)
shell (4)
smartphones (1)
soap (1)
Solid (2)
sonarqube (1)
spaceship (1)
sql (41)
sqlite (1)
ssh (3)
storage (1)
Structurizr (1)
sw (1)
Swoole (1)
Swoole (1)
symfony (1)
tailwind (1)
tecnologia (14)
telefonia (1)
tensorflow (1)
terminal (3)
traefik (1)
transaction (1)
Transcribe (2)
transcription (1)
transformers (1)
translate (1)
TypeScript (1)
ubuntu (57)
unix (2)
usb (1)
vala (1)
Variados (109)
vicuna (1)
vim (4)
vpn (1)
vscode (3)
vue (4)
web (2)
webdev (24)
webhook (1)
webservice (6)
websocket (2)
windows (6)
wine (1)
wsl (4)
wsl2 (1)
yarn (0)
zend (1)
zorin-os (1)
zsh (2)