/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 vote223 views1 answer
Git pull is a shorthand for which commands
Shell/Bash
9 votes192 views3 answers
Ubuntu rename user login
Shell/Bash
0 vote198 views2 answers
Unable to import wx
Shell/Bash
0 vote202 views1 answer
Crictl image prune
Shell/Bash
20 votes213 views6 answers
Image in github readme
Shell/Bash
0 vote208 views1 answer
Linux count lines csv files
Shell/Bash
0 vote204 views1 answer
How to rename origin in git
Shell/Bash
8 votes199 views1 answer
How to restart the network in ubuntu
Shell/Bash
0 vote203 views2 answers
Linux search string in source recursively
Shell/Bash
0 vote219 views1 answer
How to give git your email address
Shell/Bash