How do I alter a column in postgresql?



How do I alter a column in postgresql?..

Answer / Arun Kumar Attri

To alter a column in PostgreSQL, you can use the ALTER TABLE command followed by the name of the table and the ALTER COLUMN syntax. For example: ALTER TABLE my_table ALTER COLUMN my_column TYPE new_data_type;.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

Does unique index improve performance?

1 Answers  


Can postgresql scale horizontally?

1 Answers  


Explain about string constants?

1 Answers  


How do you delete a row in a table?

1 Answers  


How do you delete a column?

1 Answers  


What is performance_schema?

1 Answers  


What is the latest version of postgresql?

0 Answers  


What is the difference between a primary key and a composite key?

1 Answers  


How do you run a query in pgadmin 3?

1 Answers  


What is character varying in postgres?

1 Answers  


How do I remove all rows from a table?

1 Answers  


What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes

1 Answers  


Categories