Currently browsing category

English

English Version Blog of Ruby PDF

How to Install PostgreSQL on MacOS

Just a short list to show the ways to install Postgres on the Mac. MacPorts

sudo port install postgresql11-server

1	sudo port install postgresql11-server

Homebrew

brew install postgres

1	brew install postgres

Postgres.app Postgres.app is a …

how to compile and install clickhousedb_fdw

clickhousedb_fdw is another PostgreSQL’s Foreign Data Wrapper For ClickHouse, bases on unixodbc. The clickhousedb_fdw is open-source. It is a Foreign Data Wrapper …

PostgreSQL:Get the Day Name of Week with One SQL

first show the sql,

select (array['Sun' ,'Mon', 'Tue', 'Wed', 'Thur', 'Fri', 'Sat'])
[extract(dow from  now())+1];

1 2	select (array['Sun' ,'Mon', 'Tue', 'Wed', 'Thur', 'Fri', 'Sat']) [extract(dow from now())+1];

dow means The day of week as Sunday (0) to Saturday (6), so you just need now …