Hi, Bobb, Fundamentally, PostGIS/PostgresSQL can be used to create a database. When one creates a table, the table is defined. Namely, a schema is created and defined. Am I right?
Can we define a schema so that all other applications including ArcGIS, MapInfo and QGIS can read? Regards, Shao On Fri, 23 Aug 2019 at 14:29, Basques, Bob (CI-StPaul) < bob.basq...@ci.stpaul.mn.us> wrote: > Correct. One or more tables can be defined in a schema. > > > On Aug 23, 2019, at 3:36 AM, Shaozhong SHI <shishaozh...@gmail.com> wrote: > > *Think Before You Click: *This email originated *outside *our > organization. > > Hi, Bobb, > > A database has many schemas. > > A schema is a definition of a data structure. Many tables can be created > by using this data structure. > > Am I right? > > Regards, > > Shao > > On Thu, 22 Aug 2019 at 17:25, Basques, Bob (CI-StPaul) < > bob.basq...@ci.stpaul.mn.us> wrote: > >> Shao, >> >> I’ve always thought of a schema as a sub-grouping inside of a database, >> as in a database can contain many schemas. >> >> Or, from a higher point of view . . . >> >> Database instances (Postgres, Oracle, MySQL, etc) contain one or more >> databases, and each database can contain one or more schemas . . . >> >> bobb >> >> >> >> On Aug 22, 2019, at 11:07 AM, Shaozhong SHI <shishaozh...@gmail.com> >> wrote: >> >> *Think Before You Click: *This email originated *outside *our >> organization. >> >> Hi, Bobb, >> >> Thanks. >> >> A lot of technical terms used are interchangeable. >> >> Am I right to say this? When a postgreSQL database is created, a data >> structure is created. This data structure is referred to as a scheme? >> >> Namely, in this instance, a scheme = a data structure created with >> postgreSQL executables. >> >> Am I right? >> >> Regards, >> >> Shao >> >> On Thu, 22 Aug 2019 at 16:37, Andy Anderson <aander...@amherst.edu> >> wrote: >> >>> Thanks for the correction, Paul, I guess I’ve been relying on my MySQL >>> experience, which stores user data in the "mysql" database. >>> >>> — Andy >>> >>> On Aug 21, 2019, at 12:59 PM, Paul Ramsey <pram...@cleverelephant.ca> >>> wrote: >>> >>> This is not actually so. There’s nothing special about the postgres >>> database, drop it and see. The system information lives in system catalogs >>> that are not attached to any particular database. The template0 and >>> template1 databases are “special” in that new databases are created by >>> copying the contents of those templates, so alterations to them will >>> percolate into any new databases created, so they should generally be left >>> alone (unless you have a reason to want something included in all new >>> databases). If you drop template1 you will find it hard to create new >>> databases (unless you specify a different template) but otherwise things >>> will keep running. >>> >>> Anyways, I imagine the mystery of the Esri connection to ‘postgres’ is >>> just that someone at Esri thought the same as you, seeing that most builds >>> of postgres do ship with a postgres database already created, so that the >>> postgres database user can easily have something to connect to that is not >>> one of the templates. But it’s not special, it’s just a database. >>> >>> P. >>> >>> On Aug 21, 2019, at 9:33 AM, Andy Anderson <aander...@amherst.edu> >>> wrote: >>> >>> The postgres database is set up by default by the postgres server and >>> holds configuration information: databases, users, etc. Don’t touch. Set up >>> another database for Arc to use. >>> >>> — Andy >>> >>> On Aug 21, 2019, at 12:23 PM, Basques, Bob (CI-StPaul) < >>> bob.basq...@ci.stpaul.mn.us> wrote: >>> >>> That’s what I’m talking about. when I first tried to connect to Posters >>> (and the “postgres” named database, I kept getting an error from ArcGIS >>> saying the the “postgres” name for a database was a bad thing, and it >>> wouldn’t connect. After much searching, I discover that the name, >>> “postgres” for a database wasn’t allowed by the ArcGIS client to connect >>> to. >>> >>> As long as you don’t try connecting to the default “postgres” database, >>> all seem to work fine. >>> >>> bobb >>> >>> >>> >>> On Aug 21, 2019, at 10:59 AM, Shaozhong SHI <shishaozh...@gmail.com> >>> wrote: >>> >>> *Think Before You Click: *This email originated *outside *our >>> organization. >>> >>> Hi, Bobb, >>> >>> I am confused with this. >>> >>> The idea is to use ArcGIS desktops to read data from PostGIS/PostgreSQL. >>> >>> How best to configure and make them happy to talk to each other? >>> >>> Regards, >>> >>> Shao >>> >>> On Wed, 21 Aug 2019 at 15:01, Basques, Bob (CI-StPaul) < >>> bob.basq...@ci.stpaul.mn.us> wrote: >>> >>>> Shao, >>>> >>>> I had to dig fairly deeply into the ESRI site to find this particular >>>> explanation for why the service couldn’t/wouldn’t get connected. Just to >>>> be clear, we do use logins for accessing the database, we just have chosen >>>> to use the “postgres” (named) database. >>>> >>>> So, I just went and tried to find the refence I found previously, and >>>> can’t find it (real quick). Anyway,as long as you don’t try to connect to >>>> the “postgres” database, things do seem to work ok. >>>> >>>> bobb >>>> >>>> >>>> >>>> >>>> >>>> On Aug 21, 2019, at 2:18 AM, Shaozhong SHI <shishaozh...@gmail.com> >>>> wrote: >>>> >>>> *Think Before You Click: *This email originated *outside *our >>>> organization. >>>> >>>> Hi, Bob, >>>> Can you point me to excellent technical documentation on what you >>>> mentioned, so that I can double-check. >>>> My colleagues have made it working, but there are some issues. For >>>> instance, not all ArcGIS desktops can access and retrieve data. >>>> >>>> Looking forward to have more insight into this matter. >>>> >>>> Regards, >>>> >>>> Shao >>>> >>>> On Tue, 20 Aug 2019 at 17:08, Basques, Bob (CI-StPaul) < >>>> bob.basq...@ci.stpaul.mn.us> wrote: >>>> >>>>> All, >>>>> >>>>> One biggie, is that the ESRI side does not like connecting to the >>>>> “postgres” named database, claiming it’s a System database (whatever that >>>>> means). This is not readily available as a limitation either when looking >>>>> for reasons why it won’t connect. We’ve been using the “postgres” >>>>> database >>>>> name for years (a decade now??) with no ill effects from other >>>>> applications/ connections. I sort of understand this from the commercial >>>>> side having worked with other databases like Oracle and MSSQL, but still, >>>>> there should be a way to side step this with a setting somewhere. >>>>> >>>>> I looked high and low for a way to alias the “postgres” database name >>>>> inside of Postgres, but didn’t find anything very easy to implement or >>>>> maintain very easily. I did think about setting up another dataabase and >>>>> using Views to the postgres database, but that seemed like a bad idea for >>>>> some reason, along with being somewhat hard to maintain, but upon >>>>> reflection I keep coming back to the idea. >>>>> >>>>> All non “postgres” named connections seem to work fine so far. >>>>> Haven’t implemented anything yet that is really heavy duty as far as >>>>> loading though, so who knows. >>>>> >>>>> Anyway, just my 2cents. >>>>> >>>>> bobb >>>>> >>>>> >>>>> >>>>> On Aug 20, 2019, at 10:12 AM, Shaozhong SHI <shishaozh...@gmail.com> >>>>> wrote: >>>>> >>>>> *Think Before You Click: *This email originated *outside *our >>>>> organization. >>>>> >>>>> How to ensure that all versions of ArcGIS desktop applications can >>>>> access and read from server-based PostGIS/PostgreSQL? >>>>> >>>>> Regards, >>>>> >>>>> Shao >>>>> _______________________________________________ >>>>> postgis-users mailing list >>>>> postgis-users@lists.osgeo.org >>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>>> >>>>> >>>>> _______________________________________________ >>>>> postgis-users mailing list >>>>> postgis-users@lists.osgeo.org >>>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> postgis-users@lists.osgeo.org >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>>> >>>> >>>> _______________________________________________ >>>> postgis-users mailing list >>>> postgis-users@lists.osgeo.org >>>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >>> >>> >>> _______________________________________________ >>> postgis-users mailing list >>> postgis-users@lists.osgeo.org >>> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users >> >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
