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;
____________________________
Best regards. Nafiseh Saberi
www.iraninfocenter.net
www.sorna.net
Beauty is in the eye of the beholder.
_____________________________
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 me.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
