/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

0 vote365 views2 answers
Postgresql change user role grant
SQL
0 vote384 views1 answer
Mysql remove bad character from all fields
SQL
1 vote297 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote352 views1 answer
Set column width in sqlplus
SQL
-1 vote391 views1 answer
Brisanje dupliranih konatakata
SQL
3 votes379 views1 answer
Sql insert inserted id
SQL
0 vote323 views1 answer
Mariadb list tables
SQL
0 vote392 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote371 views1 answer
Datetime postgres typeorm
SQL
1 vote351 views1 answer
Media sql
SQL

Share