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 |
Does unique index improve performance?
Can postgresql scale horizontally?
Explain about string constants?
How do you delete a row in a table?
How do you delete a column?
What is performance_schema?
What is the latest version of postgresql?
What is the difference between a primary key and a composite key?
How do you run a query in pgadmin 3?
What is character varying in postgres?
How do I remove all rows from a table?
What is the option used in PostgreSQL to increase the number of shared memory buffers shared among the backend processes
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)