Skip to main content
Question

Specify schema name in PostgreSQL database writer (Arcsde)

  • March 15, 2024
  • 1 reply
  • 88 views

dwillow
Contributor
Forum|alt.badge.img+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

evieatsafe
Safer
  • Safer
  • March 19, 2024

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


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