/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 vote184 views1 answer
Run MongoDB manually as a background process macos
Shell/Bash
0 vote150 views1 answer
Urandom to ascii
Shell/Bash
3 votes142 views4 answers
Install pytest
Shell/Bash
0 vote163 views2 answers
SSH remote capture Wireshark
Shell/Bash
0 vote110 views2 answers
Github actions cache apt packages
Shell/Bash
0 vote147 views1 answer
Error failed to commit transaction (failed to retrieve some files)
Shell/Bash
0 vote163 views1 answer
Install gnome-clocks ubuntu
Shell/Bash
0 vote146 views1 answer
How to setup path using git bash in windows
Shell/Bash
0 vote151 views1 answer
How to unmerge branch in git
Shell/Bash
1 vote145 views3 answers
New repository
Shell/Bash