Re: PGAdmin: type geography does not exist

To add more info to this,

types in postgres are schema bound. There is no knowing where the geography
type is in your database. You might want to check all the schema to find
where the type is, its in public by default unless you renamed public, and
add it to the search path. Also, If you have some sort of multi tenancy
system, you might want to use "$user" in the search path. So that other
users don't have to prefix their queries.

SET search_path TO "$user",public;

On Tue, Aug 6, 2019 at 6:02 PM Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
wrote:

> If you're running from the sql editor, then - you have either of the two
> options:
> Set search_path = 'teleon, public';
> CREATE TABLE...
>
> Or,
>
> Specify the schema in front of tge type.
>
> -- Thanks, Ashesh
>
>
> On Tue, 6 Aug 2019, 17:14 Tony Shelver, <tshelver(at)gmail(dot)com> wrote:
>
>> Schema | Name | Description
>> --------+-----------+----------------------------------------------
>> | geography | postgis type: Ellipsoidal spatial data type.
>> (1 row)
>>
>>
>> On Tue, 6 Aug 2019 at 12:36, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
>> wrote:
>>
>>> And - the following command for psql?
>>> \dT geography
>>>
>>> --
>>>
>>> Thanks & Regards,
>>>
>>> Ashesh Vashi
>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>> <http://www.enterprisedb.com>
>>>
>>>
>>> *http://www.linkedin.com/in/asheshvashi*
>>> <http://www.linkedin.com/in/asheshvashi>
>>>
>>>
>>> On Tue, Aug 6, 2019 at 4:02 PM Tony Shelver <tshelver(at)gmail(dot)com> wrote:
>>>
>>>>
>>>>
>>>> On Tue, 6 Aug 2019 at 12:18, Ashesh Vashi <
>>>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>>
>>>>> Can you please let me know the output of 'SHOW search_path' from the
>>>>> psql?
>>>>>
>>>>
>>>>
>>>> Ashesh, if I run SHOW search_path in psql, there is no output. Just
>>>> returns with the prompt.
>>>>
>>>>