postgresql change varchar to integer

Question

I want to convert column type from varchar to integer in postgresql

ALTER TABLE billdetail ALTER COLUMN  masterid TYPE integer;

gives

[Err] ERROR:  column "masterid" cannot be cast automatically to type integer
HINT:  You might need to specify "USING masterid::integer".

while

   ALTER TABLE billdetail USING masterid::integer;

gives

[Err] ERROR:  syntax error at or near "USING"
LINE 1: ALTER TABLE billdetail USING masterid::integer;

How can I fix this problem?

Sachi Tekina · Accepted Answer · 2018-05-08 02:12:02Z

8

Try,

ALTER TABLE billdetail 
        ALTER COLUMN masterid TYPE INT USING masterid::integer;

You forgot to alter the column.

answered May 8, 2018 at 2:12

Sachi Tekina

1,8105 gold badges29 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Santhiya S · Accepted Answer · 2024-02-13 10:41:42Z

0

ALTER TABLE table_name ALTER COLUMN col_name TYPE INT USING col_name::integer;

edited Feb 13, 2024 at 10:41

answered Dec 13, 2023 at 12:09

Santhiya S

12 bronze badges

1 Comment

Jeremy Caney Over a year ago

Thank you for contributing to the Stack Overflow community. This may be a correct answer, but it’d be really useful to provide additional explanation of your code so developers can understand your reasoning. This is especially useful for new developers who aren’t as familiar with the syntax or struggling to understand the concepts. Would you kindly edit your answer to include additional details for the benefit of the community?

Collectives™ on Stack Overflow

postgresql change varchar to integer

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related