Skip to main content
  • EN

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

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

Thanks

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

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

 

 

Hi

In the Feature type to read I only obtain public.

I just want to obtain the schema name...

Hi

it's working with a simple SQLExecutor

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.

 

Hi

it's working with a simple SQLExecutor

Great 🙂

 

 

Reply


Community Stats

30,092
Posts
114,247
Replies
37,720
Members
Terms & ConditionsCookie 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.