/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 vote226 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
3 votes225 views2 answers
How to delete git repo locally
SQL
5 votes271 views1 answer
Oracle source query
SQL
2 votes209 views1 answer
Pandas to sql index
SQL
0 vote215 views1 answer
Sql anywhere create procedure
SQL
1 vote232 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote215 views1 answer
Mysql wsrep ls
SQL
0 vote222 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
1 vote196 views1 answer
Minus vs intersect in sql
SQL
1 vote214 views1 answer
How to find median of a column sql
SQL

Share