/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 vote123 views1 answer
How to count null values in sql
SQL
0 vote136 views1 answer
Joins vs includes
SQL
0 vote134 views3 answers
Database restoring error
SQL
0 vote129 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote167 views1 answer
Oracle drop chain step
SQL
0 vote135 views1 answer
What is between keyword used for
SQL
11 votes120 views2 answers
Having clause
SQL
7 votes128 views2 answers
Phpmyadmin change password
SQL
1 vote157 views1 answer
How to select random rows from a table
SQL
13 votes127 views1 answer
Fetch first 5 rows in oracle sql developer
SQL

Share