/SQL/PostgreSQL add column

PostgreSQL add 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

Alter table add multiple columns postgresql

        
            
        
     ALTER TABLE customer 
ADD COLUMN fax VARCHAR,
ADD COLUMN email VARCHAR;

3

Source: postgresqltutorial.com

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

7 votes89 views2 answers
Show size database mysql
SQL
0 vote99 views1 answer
MySQL error code 2068
SQL
0 vote110 views1 answer
Select even number id data from table
SQL
28 votes100 views6 answers
Sql update
SQL
1 vote160 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
5 votes91 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote104 views1 answer
How to connect to mysql in ef 6
SQL
5 votes109 views1 answer
Oracle nls parameters
SQL
4 votes103 views1 answer
Oracle select first 10 rows
SQL
0 vote101 views1 answer
QUERY JPQL
SQL

Share