Re: [SQL] Change of data type

2006-08-07 Thread jason nordwick
On pg8, to change tab.col to type t: alter table tab alter column col type t so: alter table tab alter column material type text -j Judith wrote: Hello everybody, excuse me how can I change de data type of a field, I currently have: material character(30) but I now want the fi

[SQL] Change of data type

2006-08-07 Thread Judith
Hello everybody, excuse me how can I change de data type of a field, I currently have: material character(30) but I now want the field in text type like this: material text somebody knows if ALTER TABLE has some option to do this?, or How can I do that? -

Re: [SQL] viewing the description of tables from python DB-API

2006-08-07 Thread George Young
On Tue, 1 Aug 2006 15:30:48 -0700 "Daniel Joo" <[EMAIL PROTECTED]> wrote: > Is there a way to view the list of all tables from python (or any other > languages for that matter) DB-API? What I'm looking for is a command > similar to the meta-command '\d' that works with the psql client. The cur