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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
