| From: | Jyry Kuukkanen <jyry(at)neutech(dot)fi> |
|---|---|
| To: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
| Cc: | shreedhar <shreedhar(at)lucidindia(dot)net>, pgsql <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to change datatype of a field |
| Date: | 2002-05-26 08:24:19 |
| Message-ID: | Pine.LNX.4.33L0.0205261122280.19676-100000@cyclone.neutech.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah. | 2002-05-26 10:28:18 | Re: Index file size keeps on growing..... |
| Previous Message | Ragnar Kjørstad | 2002-05-25 20:01:19 | Re: databases and RAID ... |