/Shell/Bash/Connecting to timescaledb from terminal

Connecting to timescaledb from terminal

sudo su -l postgres
psql

Connecting to timescaledb from terminal

CREATE database test_db;

#change into the test_db:
\c test_db

Output:
You are now connected to database "test_db" as user "postgres".

#create TimescaleDB extension:
CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

Similar codes

37 votes204 views6 answers
Git discard unstaged files
Shell/Bash
10 votes211 views5 answers
Git merge
Shell/Bash
1 vote251 views3 answers
Cmd flutter doctor says android studio is not installed
Shell/Bash
0 vote213 views1 answer
Unzip rar
Shell/Bash
0 vote244 views3 answers
How to update mongodb in ubuntu 18.04
Shell/Bash
22 votes233 views3 answers
Kill all processes holding a port
Shell/Bash
-1 vote217 views1 answer
Delete all folders except one linux
Shell/Bash
1 vote231 views1 answer
How to install staruml on ubuntu 18.04
Shell/Bash
1 vote204 views4 answers
Kill x server
Shell/Bash
1 vote228 views1 answer
Number fo files prestn in gcs bucket command
Shell/Bash