/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 vote361 views1 answer
Mysql default timestamp value to be current timestamp
SQL
1 vote388 views1 answer
Mysql last year
SQL
21 votes377 views1 answer
SQL cheat sheet pdf
SQL
0 vote371 views1 answer
How to get data from 2 database
SQL
4 votes411 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote372 views1 answer
Get schema of table sql
SQL
7 votes351 views1 answer
Postgres base size
SQL
0 vote405 views2 answers
List all constraints in postgres
SQL
13 votes350 views2 answers
Mysql order by multiple columns
SQL
0 vote360 views1 answer
Copy Table from SQL to CSV
SQL

Share