Skip to main content
Solved

Change postgres schema of a reader

  • November 10, 2018
  • 4 replies
  • 19 views

Forum|alt.badge.img

Hi,

My question is quite simple but I don't find the solution:

Is it possible to change the schema of a postgres reader, and even the table name ?

This field is disabled when I try to edit the reader (see below).

The only solution I found is to recreate the reader.

Thanks for any answer.

 

Christian

Best answer by takashi

Hi, by default, you cannot edit the schema (table name, field names, field data types) shown in a reader feature type, but here's an option to allow you to edit them.

Workbench menu: Tools > FME Options

View original
Did this help you find an answer to your question?

4 replies

takashi
Influencer
  • November 10, 2018

Hi, looks your screenshot cannot be accessed for some reason. Could you please re-post that?


Forum|alt.badge.img
  • Author
  • November 10, 2018
takashi wrote:

Hi, looks your screenshot cannot be accessed for some reason. Could you please re-post that?

Indeed, strange...

Here it is.

fme -- change schema pg reader.jpg


takashi
Influencer
  • Best Answer
  • November 10, 2018

Hi, by default, you cannot edit the schema (table name, field names, field data types) shown in a reader feature type, but here's an option to allow you to edit them.

Workbench menu: Tools > FME Options


Forum|alt.badge.img
  • Author
  • November 11, 2018
takashi wrote:

Hi, by default, you cannot edit the schema (table name, field names, field data types) shown in a reader feature type, but here's an option to allow you to edit them.

Workbench menu: Tools > FME Options

Oh, that was so simple ! Many thanks (once again) Takashi !


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