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
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?
-
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