/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

2 votes141 views1 answer
Check directory size
Shell/Bash
0 vote184 views1 answer
Powershell replace and rename file name
Shell/Bash
3 votes161 views1 answer
Zsh: command not found: rvm on terminal load
Shell/Bash
0 vote218 views1 answer
From terminal to file explorer
Shell/Bash
1 vote170 views1 answer
Kali linux desktop gadgets
Shell/Bash
1 vote155 views1 answer
Bash find full path
Shell/Bash
0 vote152 views1 answer
Preserve bash history
Shell/Bash
14 votes158 views3 answers
Git asking for password every time
Shell/Bash
0 vote155 views1 answer
Microstack change horizon port
Shell/Bash
0 vote153 views1 answer
Bash set
Shell/Bash