/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 vote88 views5 answers
Install adb
Shell/Bash
0 vote97 views1 answer
Cmd file list to text
Shell/Bash
2 votes64 views1 answer
Command to download vs code in linux
Shell/Bash
0 vote106 views2 answers
How to move file using move command cmd
Shell/Bash
0 vote96 views1 answer
Crontab execute shell script
Shell/Bash
1 vote110 views2 answers
Yarn update all
Shell/Bash
3 votes118 views1 answer
Notepad++ kali
Shell/Bash
0 vote107 views1 answer
Git see pending push
Shell/Bash
0 vote58 views1 answer
Net start docker
Shell/Bash
1 vote100 views1 answer
Un innstall dot net ubuntu
Shell/Bash