/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 vote137 views1 answer
Change directory on WSL
Shell/Bash
2 votes107 views2 answers
Instalar ftp en ubuntu
Shell/Bash
0 vote210 views1 answer
Ufw add rule with comment
Shell/Bash
0 vote197 views2 answers
Uninstall mongodb on macos completely
Shell/Bash
22 votes144 views3 answers
Ionic capacitor v3 add android
Shell/Bash
0 vote141 views1 answer
Sed remove until first occurrence
Shell/Bash
21 votes144 views4 answers
Ubuntu get process on port
Shell/Bash
0 vote138 views1 answer
Git add only c files
Shell/Bash
0 vote141 views1 answer
How to uninstall a aur package
Shell/Bash
6 votes149 views1 answer
Git error needs merge
Shell/Bash