Copy multiple CSV files on PostgreSQL database

Do the CSV’s all have the same schema/columns?

Under the parameters of the CSV reader, you can preview the schema. Test the manual vs automatic preview to see if the files are consistent. 

If there are (any) differences, you can edit the input csv’s manually, or you can learn about Dynamic reading and writing, where you will need to expose attributes (if using the generic output port of a featureReader. I make use of inspecting the Feature information and the fme_feature_type for each CSV file.

Then rename attributes that need them, so you can  present the same attributes to the writer, where the should match with the user attributes you have manually set.

CSV’s have diferent columns, and some diferent schemas , but i want all of them in the same schema in postgresql

I understand that, but my problem is that i wont be able to see how many files are in the folder, because it can be 2,3,6 or even more ….

So i just need to copy all of them into postgresql database

dynamic reading is the answer...with some attributeRenaming of know instances… perhaps the SchemaMapper if you want to control the mapping outside of FME….here are some other examples 

• Reading CSV tables with changing attributes

https://www.youtube.com/watch?v=Qt01oKI5Ut0 

the pattern you are after may have some of these elements,

If you have coodinateFields, set that in the Reader parameters, then you can write the geom into an attribute. Schema scanner is an excellent transformer for dynamic workflows. However, manipulating the schema has to be performed in the data and schema port data streams. Schema is list manipulation

Thank you for your help, i will give it a try