Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql change column type


        
            
        
     ALTER TABLE assets ALTER COLUMN name TYPE VARCHAR;
Comment

update column data type postgres

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

change data type postgresql

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

PREVIOUS NEXT
Code Example
Sql :: adding generated time in row mysql workbench 
Sql :: drop sequence 
Sql :: SQL Greater Than or Equal to Operator 
Sql :: version and edition of SQL Server Database Engine 
Sql :: mysql backup database command line 
Sql :: sql count unique values in one column 
Sql :: mysqldump with where clause 
Sql :: import sql in postgresql 
Sql :: spring boot working with sql database connection 
Sql :: mysql age by birthdate 
Sql :: drop a view in sqlite 
Sql :: oracle table free space 
Sql :: mysql delete database 
Sql :: mysql to uppercase 
Sql :: set value to null sql 
Sql :: if column value is null then in mysql 
Sql :: how to join tables in sql 
Sql :: oracle duration between timestamps 
Sql :: SQL Multi-line Comments 
Sql :: login phpmyadmin without password 
Sql :: create table as select * from table mssql 
Sql :: sql rtrim 
Sql :: pl sql 
Sql :: expo sqlite 
Sql :: sql get character at index 
Sql :: select from select sql server 
Sql :: mysql time 
Sql :: union vs intersect sql 
Sql :: mssql server port 
Sql :: creating sqeuence in oracle database 
ADD CONTENT
Topic
Content
Source link
Name
3+2 =