/SQL/Postgresql change column type

Postgresql change column type

Postgresql change column type

        
            
        
     ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;

9

Source: postgresqltutorial.com

How to change column type psql

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;

4

Source: postgresqltutorial.com

Update column data type postgres

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;

2

Source: postgresqltutorial.com

Similar codes

0 vote316 views1 answer
Query archive mode
SQL
11 votes299 views1 answer
How to get ddl for materialized view
SQL
0 vote290 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote331 views1 answer
Get initials name in sql
SQL
0 vote338 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote322 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote314 views1 answer
How to display value of variable in mysql
SQL
13 votes328 views1 answer
Sql join 3 tables on id
SQL
2 votes328 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote337 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL

Share