/SQL/Postgresql insert column

Postgresql insert column

Postgresql add column with constraint

ALTER TABLE customers 
ADD COLUMN contact_name VARCHAR NOT NULL;

31

Source: postgresqltutorial.com

Postgresql insert column

ALTER TABLE table_name
ADD COLUMN new_column_name data_type constraint;

4

Postgres how to add field created at

CREATE TABLE my_table
(
	id serial NOT NULL,
    user_name text,
	created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP //here
)

2

Similar codes

6 votes140 views2 answers
Sql query to get the number of rows in a table
SQL
12 votes135 views1 answer
Docker run mysql image
SQL
0 vote128 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote136 views1 answer
How to reset the database value in SQL server
SQL
0 vote121 views1 answer
Oracle simple quote
SQL
1 vote136 views1 answer
Nullif postgresql
SQL
1 vote138 views1 answer
Join to find results not in another table
SQL
0 vote128 views1 answer
Sql sort ages
SQL
17 votes134 views3 answers
Postgresql version command
SQL
0 vote133 views4 answers
Postgresql between month
SQL

Share