/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 vote229 views1 answer
Cerbot apache install
Shell/Bash
6 votes263 views3 answers
Convert crt to pem
Shell/Bash
0 vote294 views1 answer
Godaddy ssl integration to the ubuntu apache
Shell/Bash
2 votes247 views1 answer
Ubuntu cleanup systemd journal
Shell/Bash
12 votes224 views2 answers
How to completely remove node from ubuntu
Shell/Bash
1 vote285 views1 answer
Using ffmpeg to split video files by size
Shell/Bash
0 vote211 views1 answer
Bash get width of terminal
Shell/Bash
-2 votes276 views1 answer
How to upload a unity game to github
Shell/Bash
5 votes230 views2 answers
Heroku and github on termi
Shell/Bash
0 vote228 views1 answer
Odoo 11 Development In Ubuntu 18.04 Using Pycharm
Shell/Bash