/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

2 votes372 views2 answers
Move multiple directories linux
Shell/Bash
0 vote362 views1 answer
Powershell list usb devices
Shell/Bash
0 vote390 views1 answer
Symfony5 bundle shema
Shell/Bash
0 vote338 views1 answer
Generating javadoc
Shell/Bash
1 vote357 views1 answer
Connect ps4 controller to pc linux
Shell/Bash
0 vote345 views1 answer
Git copy stash entry from one repo to another
Shell/Bash
95 votes332 views6 answers
Change git username and email
Shell/Bash
1 vote347 views1 answer
Ubuntu delete files older than 5 days
Shell/Bash
0 vote361 views1 answer
Kafka confluent download
Shell/Bash
0 vote368 views1 answer
How to compare files in terminal
Shell/Bash