Thread: CREATE TYPE and pgAdmin III

CREATE TYPE and pgAdmin III

From
dvanatta
Date:
I realize this is a pgAdmin question but I figure most of you use it and
could help.  I've executed the following code:

CREATE TYPE cart_saved_product AS
(
  product_id INTEGER,
  name       VARCHAR(50),
  price      NUMERIC(10, 2)
);

it created successfully but I do not see it in the pgAdmin object browser.

Where are all the types I've created in the object browser?

Thanks.
--
View this message in context: http://www.nabble.com/CREATE-TYPE-and-pgAdmin-III-tp14562891p14562891.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: CREATE TYPE and pgAdmin III

From
Raymond O'Donnell
Date:
On 31/12/2007 23:06, dvanatta wrote:
> Where are all the types I've created in the object browser?

Do you see a "Types" node at all in the tree, one level beneath the
schema in which you're working? If not, you need to go to File ->
Options -> Display tab, and make sure that "Types" is checked (near the
bottom of the list).

If the node is there, then just refresh the tree view (hitting F5 will
do it) after you create the type. It refreshes automatically when you
create objects using the GUI, but not when you write and execute the SQL
via a query window.

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------