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.


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