/SQL/Change data type postgresql

Change data type postgresql

Postgresql change column type

        
            
        
     ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;

10

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

Change data type postgresql

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
Code language: CSS (css)

1

Source: postgresqltutorial.com

Similar codes

0 vote279 views1 answer
Sqlplus change user
SQL
2 votes273 views1 answer
No data found oracle
SQL
0 vote286 views1 answer
Update and keep original value sql
SQL
0 vote276 views1 answer
Soql update query
SQL
1 vote270 views2 answers
Limit sqlserver
SQL
0 vote262 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
-2 votes268 views3 answers
Sqlite reset autoincrement
SQL
1 vote272 views1 answer
Oracle update with sequence
SQL
1 vote282 views3 answers
Drop unique key constraint in sql server
SQL
0 vote270 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL

Share