Question

Specify schema name in PostgreSQL database writer (Arcsde)

  • 15 March 2024
  • 1 reply
  • 42 views

Badge +1

I am attempting to transfer data from a file geodatabase into an enterprise geodatabase (PostgreSQL). By default, the writer copies it into either the "public" schema or the "sde" schema. However, I aim to copy the data into a schema of my choice (which is “test” in this example). Although I've attempted to add the schema name before my table name using a dot, as suggested in an older post on this forum, I am still encountering errors. Please see the attached image for reference.

 

FME Workflow

 


1 reply

Userlevel 1
Badge +15

Hi @dwillow thanks for your question! I have some suggestions for you to try:

  • If the table already exists you might be able to set the Schema on the Table Qualifier.
  • You might also be able to use the Import the dataset on the Table definition setting. 

Otherwise, it might be helpful to share your workspace here or submit a support case.

Reply