/SQL/Rename table column postgresql

Rename table column postgresql

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

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

Similar codes

5 votes366 views1 answer
Purge undo tablespace usage
SQL
0 vote429 views1 answer
Stop and start mysql
SQL
11 votes346 views1 answer
Sql query to find duplicates in column
SQL
0 vote328 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote336 views1 answer
Mssql check if date is greater than today
SQL
0 vote339 views1 answer
How to check the port of mysql installation in mac
SQL
4 votes342 views1 answer
Group by mysql and concatenate string
SQL
0 vote328 views1 answer
Char vs varchar2 in sql
SQL
0 vote330 views1 answer
Check if table exists oracle
SQL
1 vote277 views1 answer
File /etc/init.d/mysql not exists
SQL

Share