/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

9 votes290 views6 answers
ModuleNotFoundError: No module named 'psycopg2'
Shell/Bash
0 vote300 views2 answers
Get script directory bash
Shell/Bash
0 vote310 views2 answers
Dukto for ubuntu download
Shell/Bash
17 votes305 views3 answers
How to uncommit my last commit in git
Shell/Bash
2 votes274 views2 answers
Ssh agent
Shell/Bash
0 vote274 views1 answer
Rename tool numeric linux
Shell/Bash
0 vote314 views1 answer
Linux invalid filename fix
Shell/Bash
1 vote245 views1 answer
Token discord
Shell/Bash
0 vote296 views1 answer
Shell script for aws lightsail launch
Shell/Bash
3 votes304 views2 answers
Check redis server status
Shell/Bash