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