/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

-3 votes240 views1 answer
$100 dollar phones
Shell/Bash
2 votes165 views1 answer
Find text pattern in file linux
Shell/Bash
3 votes170 views2 answers
Failed to load module "canberra-gtk-module"
Shell/Bash
1 vote151 views1 answer
Find old command terminal
Shell/Bash
-1 vote273 views1 answer
How to install netflix on ubuntu 20.04
Shell/Bash
27 votes191 views2 answers
Git amend commit message after push
Shell/Bash
0 vote174 views1 answer
Why installing pandas take time in docker
Shell/Bash
1 vote300 views1 answer
Optimize github repo
Shell/Bash
2 votes165 views1 answer
Gcloud
Shell/Bash
1 vote175 views1 answer
Linux process holding deleted file
Shell/Bash