Re: FDW to postGIS Database

From: Brent Wood <pcreso(at)yahoo(dot)com>
To: Discuss List Postgres <pgsql-general(at)lists(dot)postgresql(dot)org>, Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com>
Subject: Re: FDW to postGIS Database
Date: 2022-03-07 01:35:37
Message-ID: 1445754048.863458.1646616937362@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In line below...

On Monday, March 7, 2022, 05:36:34 AM GMT+13, Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> wrote:

Let say that I have a database named stp. I also have another database
named geo that is a PostGIS database for storing geopolitical and
geospatial data. I want to set up a foreign data wrapper in stp to
connect to geo, so that for each address in stp, I only have to store
the primary key value of the lowest level geo unit, such as a city. I
can always display the city's county, state, country, whatever in views
in stp. I plan to have other databases that need geo data so I want a
single source of truth for geopolitical and geospatial data.

My questions are:
1. Do I have to install PostGIS in stp?....or is it sufficient to
install PostGIS only in geo?
If you want to use Postgis functions & datatypes in stp you will need Postgis there

2. Do I need the postgis extension in stp?  (I'm thinking yes, but I
don't want to guess.)
Isn't this the same as (1) above? (Postgis is installed via "create extension postgis;")

3. I want to geocode addresses in stp. Do I need to install any
geocoding software in stp?...or can it be used from geo?
If you can geocode in geo & access the resulting data via fdw in stp, you should not need geocoding tools in stp.If you need to access spatial data from geo in stp & geocode in stp, you will need the geocoding tools in stp.

Thanks for your help!

Sue

--
--------------------------------------
Susan E Hurst
Email:  susan(dot)hurst(at)brookhurstdata(dot)com
Mobile: 314-486-3261

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Macri 2022-03-07 01:59:31 ERROR: extra data after last expected column
Previous Message Tom Lane 2022-03-06 18:54:58 Re: Do you know a json_populate_record alternative method to create a ROW with a named field notation?