New Query layer

Question

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 · Answer

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

DanielJimenez2 · Answer

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 · Answer

What does a shapefile have to do with Query Layers?

- V