Re: PGAdmin: type geography does not exist
Ashesh Vashi <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.pgadmin |
|---|---|
| Message-ID | <CAG7mmowUXMq0a=_qU4F5Ub7C20+qvHzu4etxLgsfqFiA7DbJyQ@mail.gmail.com> |
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, <[email protected]> wrote: > Schema | Name | Description > --------+-----------+---------------------------------------------- > | geography | postgis type: Ellipsoidal spatial data type. > (1 row) > > > On Tue, 6 Aug 2019 at 12:36, Ashesh Vashi <[email protected]> > 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 <[email protected]> wrote: >> >>> >>> >>> On Tue, 6 Aug 2019 at 12:18, Ashesh Vashi <[email protected]> >>> 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. >>> >>>