/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 vote96 views2 answers
Conky manager
Shell/Bash
12 votes112 views2 answers
Ssh key mac
Shell/Bash
14 votes150 views6 answers
Python jupyter notebook
Shell/Bash
0 vote127 views1 answer
How to move master changes to branch
Shell/Bash
0 vote124 views1 answer
Chmod ax
Shell/Bash
0 vote127 views1 answer
Update to git version on mac
Shell/Bash
1 vote135 views1 answer
Firefox custom search engine
Shell/Bash
0 vote120 views1 answer
How to check python3 packages
Shell/Bash
1 vote120 views1 answer
$# in bash script
Shell/Bash
0 vote112 views1 answer
Ubuntu install jdk 14
Shell/Bash