Skip to main content
Question

Get all schema from postgis

X
Forum|alt.badge.img

Hi

I'm using FME Desktop version 2017.1.

I'm trying to obtain all schema from a postgis database name here sgl.

With the schema reader I obtain only one result which is the public schema.

And I need to obtain all my schema :

How to set my reader in ordert o get all schema ?

best regards

7 replies

danilo_fme
Evangelist
Forum|alt.badge.img+41
  • danilo_fmeEvangelist
  • Evangelist
  • July 12, 2017

Hi @xlhomme, when do you put the Reader PostGis has the option Schema:

Thanks

takashi
Contributor
Forum|alt.badge.img+19
  • takashiContributor
  • Contributor
  • July 12, 2017

Another option, you can also use the FeatureReader to read schema features only, in FME 2016.1+. FYI.

X
Forum|alt.badge.img
  • xlhomme
  • Author
  • July 12, 2017
danilo_fme wrote:

Hi @xlhomme, when do you put the Reader PostGis has the option Schema:

Thanks

Hi

 

Yes with the ostgis reader I can obtain the schema and my table. But It's not what I want : I just need to wrtie in a json file the liste of the schema of my database...

 

 

thanks

 

 

X
Forum|alt.badge.img
  • xlhomme
  • Author
  • July 12, 2017

Hi

In the Feature type to read I only obtain public.

I just want to obtain the schema name...

X
Forum|alt.badge.img
  • xlhomme
  • Author
  • July 12, 2017

Hi

it's working with a simple SQLExecutor

takashi
Contributor
Forum|alt.badge.img+19
  • takashiContributor
  • Contributor
  • July 12, 2017
xlhomme wrote:

Hi

In the Feature type to read I only obtain public.

I just want to obtain the schema name...

Try setting "sgl" to the "Schemas for Table Listing" in the PostGIS reader parameters.

 

danilo_fme
Evangelist
Forum|alt.badge.img+41
  • danilo_fmeEvangelist
  • Evangelist
  • July 12, 2017
xlhomme wrote:

Hi

it's working with a simple SQLExecutor

Great :)

 

 

Reply


Helpful Members This Week

Community Stats

30,954
Posts
117,305
Replies
38,743
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.