From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | Tony Shelver <tshelver(at)gmail(dot)com> |
Cc: | "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 11:51:08 |
Message-ID: | CAG7mmowUXMq0a=_qU4F5Ub7C20+qvHzu4etxLgsfqFiA7DbJyQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 | Avin Kavish | 2019-08-06 12:43:20 | Re: PGAdmin: type geography does not exist |
Previous Message | Tony Shelver | 2019-08-06 11:44:26 | Re: PGAdmin: type geography does not exist |