Re: How to change datatype of a field - Mailing list pgsql-admin

From Jyry Kuukkanen
Subject Re: How to change datatype of a field
Date
Msg-id Pine.LNX.4.33L0.0205261122280.19676-100000@cyclone.neutech.fi
Whole thread Raw
In response to Re: How to change datatype of a field  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: Ragnar Kjørstad
Date:
Subject: Re: databases and RAID ...
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: Index file size keeps on growing.....