Columns

Creating columns.

1create table table_name (
2  id integer primary key,
3  data jsonb,
4  name text
5);

Examples#

During table creation#

1create table table_name (
2  id integer primary key,
3  data jsonb,
4  name text
5);

Create column#

1alter table new_table
2add new_column text;