Re: PGAdmin: type geography does not exist

I'm not sure if the schema the extension is installed in is causing the
problem. I always install extensions in the pg_catalog schema.

On Tue, Aug 6, 2019 at 7:32 AM Ashesh Vashi <[email protected]>
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, <[email protected]> wrote:
>
>> Schema |   Name    |                 Description
>> --------+-----------+----------------------------------------------
>>   | geography | postgis type: Ellipsoidal spatial data type.
>> (1 row)
>>
>>
>> On Tue, 6 Aug 2019 at 12:36, Ashesh Vashi <[email protected]>
>> 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 <[email protected]> wrote:
>>>
>>>>
>>>>
>>>> On Tue, 6 Aug 2019 at 12:18, Ashesh Vashi <
>>>> [email protected]> 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.
>>>>
>>>>