Hi,
If there is a suitable cast in the database, then the combo box will be
populated with usable column types and made selectable (try it with
varchar which should be castable). Any other conversion requires the use
of the USING clause to the alter table statement which pgAdmin doesn't
support.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Walter Haslbeck
> Sent: 27 May 2005 10:48
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Alter columntype with pgadmin?
>
> Hi,
>
> > pgAdmin does support this feature in
Hi,
pgAdmin does support this feature in the 1.3 development series, but I'm
pretty sure it was in 1.2 as well.
Well, I'm using the latest binary snapshot of the win32-version
(20050526) and can't find this feature. If I open the propertys for a
column of e.g. type 'char', the datatype and s
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Walter Haslbeck
> Sent: 27 May 2005 09:12
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Alter columntype with pgadmin?
>
> Hi,
>
> now that PostgreSQL 8 supports changing the
on 27/05/2005 10:11 Walter Haslbeck said the following:
> Hi,
>
> now that PostgreSQL 8 supports changing the datatype of a column with
> the 'ALTER TABLE ... ALTER COLUMN ... TYPE new_type [USING ...]' syntax
> it would be great if pgadminIII has an option to do this via GUI.
>
> Are there any e
Hi,
now that PostgreSQL 8 supports changing the datatype of a column with
the 'ALTER TABLE ... ALTER COLUMN ... TYPE new_type [USING ...]' syntax
it would be great if pgadminIII has an option to do this via GUI.
Are there any efforts to support this feature in pgadminIII?
Walter
---