I'm looking for a way to read all the tables which are in one schema without having to select them manually. I have to export all the table which are stored in one particular schema in spatialite. New tables can be added end old one deleted. That's why I need something automatic...
Does anyone have a clue ?
Thank's
two possibilities, either dynamic schema or a combination of the reader "Schema (any format)" and a FeatureReader.
David
Does "Dynamic schema" mean "single Merges Feature type" ? how to select only a postgis schema and not a table ?
If I chose "Schema (any format)", I can apparently add only directories or files in the dataset. How can I select the postgis database ?
Cheers
I do not know of any very simple way of doing this, you will probably have to be a bit creative.
To get a list of all the tables with a geometry column in PostGIS ("feature classes", if you will), you can use an SQLCreator with the following:
select array_to_string(array_agg(f_table_schema || '.' || f_table_name), ':') as featurelist from geometry_columns
This will create an attribute "featurelist" with a colon-separated list of all the tables, suitable for the FeatureReader. Hopefully you can take it from there.
David
any chance you share the python script you used, i'am trying to do the same but linked as a parameter for filtering schemas without to load all the table
Arnaud
Hi @uccelli!
I would be very much thankfull if i can get your script. I am trying something alike to read all the tables from sql server. Thanks in avdance.
Rimon
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
