connecting to timescaledb from terminal code example
Example 1: connecting to timescaledb from terminal
sudo su -l postgres
psql
Example 2: 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;