/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

1 vote324 views1 answer
How to find your ip on debian linux wsl
Shell/Bash
3 votes390 views1 answer
Export variable unset
Shell/Bash
0 vote368 views1 answer
Linux poid dossier
Shell/Bash
3 votes411 views1 answer
Install curl in alpine linux
Shell/Bash
16 votes341 views2 answers
Git command to get the repo url
Shell/Bash
0 vote332 views1 answer
How to make xcopy create destination dirs if they don't exist
Shell/Bash
0 vote330 views1 answer
Yum list installed packages from specific repo
Shell/Bash
0 vote351 views1 answer
How to do a sudo reboot on raspberry pi
Shell/Bash
1 vote397 views3 answers
Install atom ubuntu terminal
Shell/Bash
12 votes314 views3 answers
How to go to a previous commit state
Shell/Bash