Re: PGAdmin: type geography does not exist

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.