From: | Micky Hulse <mickyhulse(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: type "xxxxxxx" does not exist |
Date: | 2017-05-19 21:09:12 |
Message-ID: | CAKzdcNma6LXso-8--yONJMOYeeKhmmOjYVGycymabAzZMk_CJA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello and thanks for the help!
On Fri, May 19, 2017 at 1:25 PM, Paul Jungwirth
<pj(at)illuminatedcomputing(dot)com> wrote:
> It sounds like the type might be in a different schema. You can say \dn to
> see the schemas in your database, and \dT+ will show the types along with
> their schema. You could also do \dT+ foo.* to see all the types in schema
> foo.
Ahhhh, interesting!
\dT+ myschema.*
I see the type "xxx_xxx_xxxxx" (which is the one my method is looking for).
There are not types in the public schema:
# \dT+ public.*
List of data types
Schema | Name | Internal name | Size | Elements | Access privileges |
Description
--------+------+---------------+------+----------+-------------------+-------------
(0 rows)
> If you find that the type isn't in the public schema, try setting your
> schema search path so that the function can locate it, e.g.:
> SET search_path TO foo, public;
Cool! Dumb question, but is foo the schema or the type?
Thanks so much for the tips Paul! I really appreciate your help. :)
From | Date | Subject | |
---|---|---|---|
Next Message | Micky Hulse | 2017-05-19 21:15:39 | Re: type "xxxxxxx" does not exist |
Previous Message | Merlin Moncure | 2017-05-19 20:59:03 | Re: storing large files in database - performance |