/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

1 vote315 views1 answer
How to move hidden files in linux
Shell/Bash
0 vote350 views2 answers
Download teamviewer for ubuntu 20.04
Shell/Bash
0 vote341 views1 answer
Start of .sh file
Shell/Bash
0 vote409 views3 answers
CocoaPods not installed
Shell/Bash
0 vote356 views6 answers
Docker compose multiple command
Shell/Bash
0 vote385 views1 answer
Fdart string to uri
Shell/Bash
0 vote376 views1 answer
Git bash terminal weird characters
Shell/Bash
0 vote347 views1 answer
Npm install -g angular cli
Shell/Bash
10 votes346 views6 answers
Zsh: command not found: nvm
Shell/Bash
0 vote358 views1 answer
Git abort conflict stash
Shell/Bash