/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

5 votes693 views1 answer
Oracle ora-00054 find
SQL
0 vote113 views1 answer
Group_concat only returns one row
SQL
3 votes123 views1 answer
Create a table with an id in mysql
SQL
1 vote127 views1 answer
Sysdate in sql
SQL
0 vote117 views1 answer
Show tables in cassandra cql
SQL
0 vote118 views5 answers
Linq cheat sheet
SQL
1 vote113 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote131 views1 answer
Add mysql database to power bi web
SQL
13 votes117 views3 answers
Uninstall mysql centos 7
SQL
24 votes109 views6 answers
Rename a column in sql server
SQL

Share