Created Type's not displayed in schema - Mailing list pgadmin-support
From | Joe Moyle |
---|---|
Subject | Created Type's not displayed in schema |
Date | |
Msg-id | 8B1D2F832D92D84BB2C583614AAD7C090663C500@pmmail02.paymetric.com Whole thread Raw |
Responses |
Re: Created Type's not displayed in schema
|
List | pgadmin-support |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">To Whom It May Concern:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> I’m working on my first PostgreSQL project and have used pgAdmin III with great success. Thank you for your work on this application. </span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal" style="text-indent:.5in"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">I’musing Version 1.8.2 (Feb 4 2008, rev: 7050). When I browse the schema in ObjectBrowser I don’t see my user defined Types in the tree. Perhaps I’m just not looking in the right place. I searchon Type in Help but failed to find it. Let me show you a tiny snippet of the code I’m running that creates a typeso you see what I mean.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> CREATE TYPE "EMS"."Action_By_Hour"</span></font><p class="MsoNormal"><font face="Arial" size="2"><spanstyle="font-size:10.0pt; font-family:Arial"> AS (</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> "Day" DOUBLE PRECISION</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"Descr" CHARACTER VARYING(256)</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"Hour" DOUBLE PRECISION</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"Month" DOUBLE PRECISION</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"Success" BOOLEAN</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"User_Name" CHARACTER VARYING(64)</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"Volume_Count" BIGINT</span></font><p class="MsoNormal"><font face="Arial"size="2"><span style="font-size:10.0pt; font-family:Arial"> ,"Year" DOUBLE PRECISION</span></font><p class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> );</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> I only see Domains, Functions, Sequences, Tables, Trigger Functions, and Views in my schemabut not my Types. Is this something I’m just not configuring to display properly or is this type of schema objectnot supported by pgAdmin III yet?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;font-family:Arial">JoeMoyle</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Sr. DBA</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">Paymetric Inc.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12.0pt"> </span></font></div>
pgadmin-support by date: