/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

0 vote365 views1 answer
How to capture notification in linux
Shell/Bash
0 vote298 views1 answer
Wslcopy to system clipboard
Shell/Bash
0 vote334 views1 answer
Typescript compile specific file
Shell/Bash
1 vote305 views1 answer
See current git version
Shell/Bash
0 vote332 views1 answer
How to uninstall kite
Shell/Bash
0 vote316 views3 answers
Bloquear /var/lib/apt/lists
Shell/Bash
1 vote308 views1 answer
Brave disable gpu linux
Shell/Bash
70 votes304 views5 answers
Install docker ubuntu 20
Shell/Bash
11 votes304 views1 answer
How to check for angular cli version
Shell/Bash
1 vote352 views1 answer
Case insensitive zgrep
Shell/Bash