/SQL/Rename column postgres

Rename column postgres

Rename column postgres

ALTER TABLE customers 
RENAME COLUMN name TO customer_name;

ALTER TABLE customers
RENAME COLUMN phone TO contact_phone;

2

Source: postgresqltutorial.com

Psql filed name alter

ALTER TABLE table_name 
RENAME column_name TO new_column_name;

1

How to update column name in psql

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;

1

Rename column postgres

ALTER TABLE distributors RENAME COLUMN address TO city;

1

Source: postgrespro.ru

Rename table column postgresql

ALTER TABLE table_name 
RENAME COLUMN column_name TO new_column_name;

1

Source: postgresqltutorial.com

How to update column name in psql

ALTER TABLE order_details
  RENAME TO order_information;

0

Source: techonthenet.com

Similar codes

0 vote341 views1 answer
Primary key multiple colums
SQL
7 votes322 views1 answer
Sql server convert string to date
SQL
0 vote334 views1 answer
Mysql insert into select transaction c#
SQL
1 vote311 views1 answer
Crontab every month
SQL
0 vote367 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote344 views1 answer
What is a Database?
SQL
-1 vote306 views2 answers
Full join sql
SQL
13 votes347 views2 answers
Get date from now() mysql
SQL
0 vote315 views1 answer
Mysql docker image for macbook m1
SQL
1 vote336 views1 answer
How to start with sql
SQL

Share