/SQL/Update column data type postgres

Update column data type postgres

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

Similar codes

0 vote189 views1 answer
Mysql DDL
SQL
1 vote201 views1 answer
Sql server get users
SQL
4 votes189 views2 answers
Oracle unlock user
SQL
0 vote212 views1 answer
Call function in query sql server
SQL
1 vote202 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
5 votes274 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote207 views1 answer
T-SQL Never ending DELETE
SQL
1 vote173 views1 answer
Order by oracle
SQL
1 vote182 views1 answer
Add constraint sql
SQL
1 vote186 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL

Share