/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 vote125 views1 answer
Uninstall postman ubuntu
Shell/Bash
0 vote145 views1 answer
How to clear/delete/remove/erase/wipe/forget shell traps
Shell/Bash
18 votes146 views5 answers
Git remove cached
Shell/Bash
0 vote177 views1 answer
How to reset local git credentials of android studio
Shell/Bash
6 votes140 views1 answer
How to view a list of installed npm packages
Shell/Bash
0 vote137 views1 answer
Add files to hadoop
Shell/Bash
3 votes139 views2 answers
Find in files ubuntu
Shell/Bash
1 vote134 views1 answer
Conda install mmcv
Shell/Bash
0 vote117 views1 answer
Partially apply stash git
Shell/Bash
2 votes138 views1 answer
Linux execute permission denied
Shell/Bash