Re: PGAdmin: type geography does not exist

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема Re: PGAdmin: type geography does not exist
Дата
Msg-id CAG7mmowUXMq0a=_qU4F5Ub7C20+qvHzu4etxLgsfqFiA7DbJyQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PGAdmin: type geography does not exist  (Tony Shelver <tshelver@gmail.com>)
Ответы Re: PGAdmin: type geography does not exist  (Avin Kavish <avinkavish@gmail.com>)
Re: PGAdmin: type geography does not exist  (Michael Shapiro <mshapiro51@gmail.com>)
Re: PGAdmin: type geography does not exist  (Tony Shelver <tshelver@gmail.com>)
Список 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@gmail.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.vashi@enterprisedb.com> wrote:
And - the following command for psql?
\dT geography

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Tue, Aug 6, 2019 at 4:02 PM Tony Shelver <tshelver@gmail.com> wrote:


On Tue, 6 Aug 2019 at 12:18, Ashesh Vashi <ashesh.vashi@enterprisedb.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.

В списке pgadmin-support по дате отправления:

Предыдущее
От: Tony Shelver
Дата:
Сообщение: Re: PGAdmin: type geography does not exist
Следующее
От: Avin Kavish
Дата:
Сообщение: Re: PGAdmin: type geography does not exist