/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 vote244 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote218 views1 answer
Mysql limit order by
SQL
11 votes178 views1 answer
Get ddl materialized view oracle
SQL
0 vote222 views1 answer
Gcloud sql instance list
SQL
0 vote160 views1 answer
How to find unique key in sql
SQL
0 vote224 views1 answer
Pl sql round
SQL
0 vote188 views1 answer
C# execute transact sql
SQL
4 votes177 views1 answer
Sql delete where in select
SQL
0 vote197 views1 answer
Postgres meta command to show all rows in table
SQL
2 votes169 views2 answers
How to check database username and password in postgresql
SQL

Share