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
