/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 vote169 views1 answer
Ignore pre-commit hook
Shell/Bash
14 votes169 views3 answers
How to delete files in linux terminal
Shell/Bash
24 votes187 views6 answers
Pip3 uninstall all
Shell/Bash
0 vote203 views1 answer
To configure msmtp, let’s create a file .msmtprc in the current user home directory:
Shell/Bash
2 votes165 views1 answer
Github clone to local folder
Shell/Bash
2 votes177 views1 answer
Install Material ui on react app
Shell/Bash
47 votes182 views3 answers
Git init
Shell/Bash
13 votes177 views1 answer
Install rust apt
Shell/Bash
0 vote163 views1 answer
See output of a running processes linux
Shell/Bash
0 vote179 views1 answer
Git search branch by name
Shell/Bash