Re: PGAdmin: type geography does not exist

From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
Cc: Tony Shelver <tshelver(at)gmail(dot)com>, "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: PGAdmin: type geography does not exist
Date: 2019-08-06 13:09:22
Message-ID: CAGCvxeani0g+ZmKL250YwjneWXae7VQnAZgxtyd6myGJuLEA5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 <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.
>>>>
>>>>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Tony Shelver 2019-08-06 15:29:25 Re: PGAdmin: type geography does not exist
Previous Message Avin Kavish 2019-08-06 12:43:20 Re: PGAdmin: type geography does not exist