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