Skip to main content
Solved

Change postgres schema of a reader

  • November 10, 2018
  • 4 replies
  • 27 views
C
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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

takashi
Celebrity
  • takashiCelebrity
  • November 10, 2018

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

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
C
Forum|alt.badge.img
  • christian_b
  • Author
  • November 10, 2018

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
Celebrity
  • takashiCelebrity
  • 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

Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
C
Forum|alt.badge.img
  • christian_b
  • Author
  • November 11, 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

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

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.