/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

8 votes170 views1 answer
Oracle add months to sysdate
SQL
0 vote175 views2 answers
How to set global time_zone in mysql
SQL
1 vote195 views1 answer
Oracle see column type
SQL
2 votes178 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote167 views2 answers
String to date postgres
SQL
0 vote160 views1 answer
Mysql percentage of total
SQL
0 vote184 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote164 views1 answer
Mysql remove tabs from string
SQL
0 vote190 views1 answer
Sql cmd no truncate
SQL
0 vote199 views1 answer
Mysql relationships between tables
SQL

Share