postgresql change column code example

Example 1: how to update column name in psql

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;

Example 2: postgresql change column type

ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;

Example 3: alter column in table postgres

ALTER TABLE table_name
  ALTER COLUMN column_name TYPE column_definition;

Example 4: alter table add column postgres

Alter Postgres Table

Tags:

Sql Example

Related