How can we change the columns datatype in PostgreSQL?
devquora
Posted On: Feb 22, 2018
Use change column type statement with ALTER TABLE command to change a column type in PostgreSQL.
Example
ALTER TABLE table_name ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Postgresql Interview Questions
List some of the features of Postgresql ?
Following are some of the features of Postgresql : Object-relational database Support and Extensibility for SQL fle..
Postgresql Interview Questions
What is the option that can be used in PostgreSQL to make transactions see rows affected in previous parts of the transaction?
The SQL standard is defined by four levels of transaction isolation basically regarding three phenomena. The three phe..
Postgresql Interview Questions
Put some light on Multi-Version concurrency control?
MVCC or better known as Multi-version concurrency control is used to avoid unwanted locking of the database. The time ..