/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

18 votes325 views3 answers
Get the list of all tables in sql server
SQL
0 vote305 views1 answer
Sql alter table order by
SQL
0 vote297 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote301 views1 answer
Postgresql regular expression special characters
SQL
1 vote313 views1 answer
Postgres killing connections on db
SQL
0 vote312 views1 answer
Sql query to return field name of a table
SQL
1 vote293 views1 answer
Oracle user last connected
SQL
0 vote308 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote344 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote335 views1 answer
Mysql edit trigger
SQL

Share