/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 vote264 views1 answer
Kill proccess using serial port
Shell/Bash
2 votes186 views1 answer
How to add a custom zsh aliases
Shell/Bash
40 votes264 views5 answers
Home brew mac
Shell/Bash
1 vote202 views2 answers
Cmd list dotnet frameworks installed
Shell/Bash
2 votes176 views2 answers
Generate key and certificate openssl
Shell/Bash
12 votes208 views1 answer
Dir to file txt
Shell/Bash
0 vote195 views1 answer
How to run spigot server using bat
Shell/Bash
14 votes189 views4 answers
How to open a file using terminal
Shell/Bash
0 vote216 views2 answers
Best ide editor
Shell/Bash
0 vote182 views1 answer
Linux os update
Shell/Bash