hi..dear team.
I find it myself.
CREATE TABLE temp AS SELECT did, city FROM distributors;
DROP TABLE distributors;
CREATE TABLE distributors (
did DECIMAL(3) DEFAULT 1,
name VARCHAR(40) NOT NULL
);
INSERT INTO distributors SELECT * FROM temp;
DROP TABLE temp;
___
hi dear team...
I wish all of you be successful in all work & life.
do you know ,how can I change the type of one special
column in table in postgres ?
(i use "alter" , but it doesn't change the type of it.
i want to change from char to varchar)
thx and appreciate for any time that you get to
