Postgres Pro
Downloads
Home   >   mailing lists

Re: PGAdmin: type geography does not exist - Mailing list pgadmin-support

From Ashesh Vashi
Subject Re: PGAdmin: type geography does not exist
Date
Msg-id CAG7mmowUXMq0a=_qU4F5Ub7C20+qvHzu4etxLgsfqFiA7DbJyQ@mail.gmail.com
Whole thread Raw
In response to Re: PGAdmin: type geography does not exist  (Tony Shelver <tshelver@gmail.com>)
Responses Re: PGAdmin: type geography does not exist
Re: PGAdmin: type geography does not exist
Re: PGAdmin: type geography does not exist
List pgadmin-support
Tree view
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 by date:

Previous
From: Tony Shelver
Date:
Subject: Re: PGAdmin: type geography does not exist
Next
From: Avin Kavish
Date:
Subject: Re: PGAdmin: type geography does not exist