/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

0 vote141 views1 answer
How to run program startup linus
Shell/Bash
0 vote182 views2 answers
How to check laravel installer version
Shell/Bash
0 vote187 views1 answer
Check openvpn working
Shell/Bash
0 vote145 views1 answer
Best software development tools 2022
Shell/Bash
0 vote152 views1 answer
How to run a specific knex seed file
Shell/Bash
1 vote147 views1 answer
Xclip does not work
Shell/Bash
2 votes167 views1 answer
Magento 2 reindex command line
Shell/Bash
4 votes101 views1 answer
How to check network status in ubuntu
Shell/Bash
0 vote144 views1 answer
How to make a single digit date start with zero
Shell/Bash
0 vote149 views2 answers
Delete whole line in vi
Shell/Bash