Re: change datatype in postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Postgresql doesn't support altering the size or data type of a table field.

Prolly the quickest way for you to fix this table is to create another table
the way you want it, with the same fieldnames, but the size you wanted and do

COPY old_tablename TO '/tmp/filename';

from psql, then do

COPY new_tablename FROM '/tmp/filename';



On Wednesday 23 July 2003 19:23, Norma Ramirez - TECNOSOFT wrote:
> Thank´s Xaos, but I have a inocent question ¿why on earth can`t do with a
> simple "alter table" like other databases???
> and, o.k drop the old column buy copy the data into a new one? how? with an
> update query?
> Thank´s again and sorry if bother =)

- --
"Death is merciful, for there is no return
therefrom, but with him who has come back
out of the nethermost chambers of night,
haggard and knowing, peace rests nevermore"
- -Lovecraft
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQE/HzE/uJXVjPNiNE4RAleIAJ9IutPsH5GXt8vML53uHB4M2gU2zwCfbsCV
TBd6mZwzJi6Z9ck/17FnDX0=
=xne4
-----END PGP SIGNATURE-----


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux