/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

45 votes181 views1 answer
What is curl command
Shell/Bash
1 vote190 views1 answer
Org.apache.spark.api.python.PythonUtils.getPythonAuthSocketTimeout ubuntu
Shell/Bash
0 vote165 views1 answer
Linux updates popos
Shell/Bash
1 vote277 views1 answer
Feature branch naming convention git
Shell/Bash
6 votes182 views2 answers
Test internet speed terminal linux
Shell/Bash
38 votes188 views3 answers
Python2 pip install kali
Shell/Bash
0 vote183 views1 answer
Powerrshell adobject get all deleted
Shell/Bash
11 votes167 views5 answers
Expo cli
Shell/Bash
13 votes187 views2 answers
Conda install keras
Shell/Bash
0 vote166 views1 answer
Sum decimals bash
Shell/Bash