Lists: | pgsql-general |
---|
From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | New/Custom DataType - Altering definition / seeing definition in pgAdmin3 |
Date: | 2007-09-17 00:32:04 |
Message-ID: | 1189989124.14185.3.camel@neuromancer.home.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
I've created a new custom datatype
eg:
create type foo as (
id smallint
data1 int
data2 int
)
to view the datatype in psql I do
=> \d foo
what is the equilvalent on pgadmin3 or any other SQL query tool?
As i understand from the docs, I can't alter / change the datatype
definition. If I need to change it, I need to drop it and re-create it
again. Correct me if I'm wrong.
From: | Roberto Spier <roberto(dot)spier(at)conab(dot)gov(dot)br> |
---|---|
To: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: New/Custom DataType - Altering definition / seeing definition in pgAdmin3 |
Date: | 2007-09-17 20:28:50 |
Message-ID: | 46EEE382.5080205@conab.gov.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Ow Mun Heng escreveu:
> I've created a new custom datatype
>
> eg:
>
> create type foo as (
> id smallint
> data1 int
> data2 int
> )
>
> to view the datatype in psql I do
> => \d foo
>
> what is the equilvalent on pgadmin3 or any other SQL query tool?
>
>
Within pgAdmin3: File > Option > Display tab > set Types
> As i understand from the docs, I can't alter / change the datatype
> definition. If I need to change it, I need to drop it and re-create it
> again. Correct me if I'm wrong.
>
>
Correct. pgAdmin3 will be your friend, as it shows a commented out drop
type instruction within eery create type script.
HTH
From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: New/Custom DataType - Altering definition / seeing definition in pgAdmin3 |
Date: | 2007-09-18 04:23:04 |
Message-ID: | 1190089384.3793.51.camel@neuromancer.home.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Mon, 2007-09-17 at 17:28 -0300, Roberto Spier wrote:
> Ow Mun Heng escreveu:
> > I've created a new custom datatype
> > to view the datatype in psql I do
> > => \d foo
> >
> > what is the equilvalent on pgadmin3 or any other SQL query tool?
> >
> >
> Within pgAdmin3: File > Option > Display tab > set Types
Ah.. I see.. Many Thanks.