010 Postgres Commands

tags: postgres, database

Connect to docker’s psql

command: docker exec -it <container-name> psql -U user usage: docker exec -it timescaledb psql -U postgres

Create Database

command: create database <databse-name> usage: create database transactions

Select/Switch Database

In the postgres terminal

command: \c database_name usage: \c transactions

Create Table

command:

create table table_name (
	column1 datatype,
	column2 datatype,
	column3 datatype,
);

usage:

create table UserDataSourceCategory (
    UserDataSourceCategoryId INT primary key not null,
    CategoryName text not null,
    CategoryParentId INT,
    foreign key (CategoryParentId) references UserDataSourceCategory(UserDataSourceCategoryId)
);