Thread: How to change datatype of a field

Hi Sreedhar,

There are no commands as such but
combination of "CREATE TABLE AS SELECT f1,f2 from TAB"
and CAST might prove useful in certain cases


regds
mallah.

On Saturday 25 May 2002 12:22 pm, shreedhar wrote:
> Is there any possibility to change datatype of a field.
>
> regards,
> S Baskar

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.

On Sat, 25 May 2002, Rajesh Kumar Mallah. wrote:

> Hi Sreedhar,
>
> There are no commands as such but
> combination of "CREATE TABLE AS SELECT f1,f2 from TAB"
> and CAST might prove useful in certain cases
>
>
> regds
> mallah.
>
> On Saturday 25 May 2002 12:22 pm, shreedhar wrote:
> > Is there any possibility to change datatype of a field.
> >
> > regards,
> > S Baskar
>


You may also try installing phpPgAdmin (search http://freshmeat.org for
it) as it automates create/select/insert to drop a column and does a whole
lot more.

Cheers,
--Jyry
C:-(    C:-/    C========8-O    C8-/    C:-(

M. Schumacher will win "Monaco F1 2002". He will be second, too.
And probably third.