New Query layer

[DanielJimenez2]

I have a postgres 9.3 connected to Arcgis 10.1. I have defined the primary key on my  database  shapefile table, but every time i query the layer into gis i need to set in the advanced  new query options the primary key field in order to open the attribute table. How can i make Arcgis to remember which is the primary key of the shapefile so i don't have to keep selecting manually the PK?

[VinceAngelo]

It's not possible for ArcGIS to "remember" the registered rowid column of a newly defined
Query Layer table.  All the remembering is done by ArcSDE metadata, but Query Layers
don't have ArcSDE metadata.

Shapefiles have no direct association with Query Layer tables or enterprise geodatabase
feature classes.

- V

[DanielJimenez2]

It's not possible for ArcGIS to "remember" the registered rowid column of a newly defined
Query Layer table.  All the remembering is done by ArcSDE metadata, but Query Layers
don't have ArcSDE metadata.

Shapefiles have no direct association with Query Layer tables or enterprise geodatabase
feature classes.

- V

So every time i need to open a shapefile i need to assign a pk out of all the fields?

[VinceAngelo]

What does a shapefile have to do with Query Layers?

- V

[DanielJimenez2]

If my shapefile is in a database, then they only way to display it in arcgis is through the add quary layer option right?

[VinceAngelo]

This is important: Once data is loaded into a database, it's no longer in the format that was used to load it. What you have is a table, not a shapefile.  And yes, each time you reference a table into a new Query Layer, you'll need to set it up again. - V