Results 1 to 8 of 8

Thread: composite type

  1. #1
    Join Date
    Nov 2009
    Posts
    5

    Question Unanswered: composite type

    Hi, im new to postgresql.

    I've created a custom type to use within a function. My question is where can I view/edit/drop this type?

    thanks

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    What tools are you using? You can use pgAdmin to do all of this.

  3. #3
    Join Date
    Nov 2009
    Posts
    5
    Quote Originally Posted by artacus72 View Post
    What tools are you using? You can use pgAdmin to do all of this.
    I am using pgAdmin but for some reason i cannot see the types in the database tree. The type i've just created is valid and usable so what am i doing wrong?

  4. #4
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Types you create will wind up in your default schema not pg_catalog are you looking in your schema or public?

  5. #5
    Join Date
    Nov 2009
    Posts
    5
    Quote Originally Posted by artacus72 View Post
    Types you create will wind up in your default schema not pg_catalog are you looking in your schema or public?
    I've checked anywhere in the tree and no sing of any "type" nodes. If used in a function the type i have just created is valid.

  6. #6
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Alright, this isn't going anywhere. Why don't you tell us what you are trying to accomplish and what is happening.

  7. #7
    Join Date
    Nov 2009
    Posts
    1
    Hello,
    I am about to begin work on a similar project for a client of mine. From what I can tell there will be significant overlap in terms of features.

  8. #8
    Join Date
    Nov 2009
    Posts
    5

    resolved

    sorry i forgot to close this.
    it was a problem of client display only. the types are there
    thanks for your time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •