I get a lot of benefit out of PGAdmin without that functionality.
It's actually a database limitation, not a PGAdmin limitation.
However, if your main database activity is changing the data type of a
column in ways that are disallowed by PostGreSQL, then you are
correct. PGAdmin is pointless.
Sim
On 6/11/05 9:11 am, "Chris Velevitch" <[EMAIL PROTECTED]> wrote:
> On 11/6/05, Sim Zacks <[EMAIL PROTECTED]> wrote:
>> However, if your main database activity is changing the data type of a
>> column in ways that are disallowed by PostGreSQL, then you are
>> correct. PGAdmin is pointless.
>
>
On 11/6/05, Sim Zacks <[EMAIL PROTECTED]> wrote:
> However, if your main database activity is changing the data type of a
> column in ways that are disallowed by PostGreSQL, then you are
> correct. PGAdmin is pointless.
My main database activity is refactoring and version control of a
database. Th
On Sun, 2005-11-06 at 08:36 +, Chris wrote:
> In the end, I did this plu I dropped the old column, but what's the point of
> having a tool like pgAdmin if common place everyday activities like this can't
> be done?
Because data conversion is a major task. See
http://www.pgadmin.org/development
Joost Kraaijeveld Askesis.nl> writes:
> Does this work (replace the names according to your schema)?
>
> BEGIN;
> ALTER TABLE table_name ADD COLUMN new_column varchar(64)?;
> UPDATE table_name SET new_column = column;
> ALTER TABLE customer RENAME column TO old_column;
> ALTER TABLE customer RENA
On Sun, 2005-11-06 at 01:12 +, Chris wrote:
> I'm trying to change a char(30) to varchar(64), but I can't find a way to do
> it.
> I select the table, select properties, select the column and click change, but
> the data type and lengths are grayed out.
>
> How do I change this column from ch
How do I rename a constraint?
I'm only doing this because I can't change the type of a column from char(30) to
varchar(64). So I renamed to original table, but the constraints seems to be
globally unique. I don't know why, but this simple exercise of changing a column
type is getting very messy a
