Re: PGAdmin: type geography does not exist
| От | Avin Kavish |
|---|---|
| Тема | Re: PGAdmin: type geography does not exist |
| Дата | |
| Msg-id | CAFpscOSgJv95C395+dokP5ub32PKcr_VO5rXZmgRmi=OsDHHbQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PGAdmin: type geography does not exist (Ashesh Vashi <ashesh.vashi@enterprisedb.com>) |
| Список | pgadmin-support |
To add more info to this,
types in postgres are schema bound. There is no knowing where the geography type is in your database. You might want to check all the schema to find where the type is, its in public by default unless you renamed public, and add it to the search path. Also, If you have some sort of multi tenancy system, you might want to use "$user" in the search path. So that other users don't have to prefix their queries.
SET search_path TO "$user",public;
On Tue, Aug 6, 2019 at 6:02 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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, AsheshOn 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 geographyOn 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 по дате отправления: