example of some tables breakdown in pg4admin gui, demonstrating how there are NO indexes created on primary keys shown 0_o (in the first table see, the "indexes" tab is opened too)
checking the structure of the same tables from previous pic with the psql tool (still in pg4admin app). here the indexes listed include these on primary keys
sql server management studio's table breakdown gui for comparison, primary key indexes are shown
today i learned... rather confirmed my suspicion that sql makes indexes for primary keys
but why doesnt pg4dmin show them in table dropdown, I already thought that stuff works differently in various DBMSes
whew, no, here they are PK indexes seen in psql
#sql #postgres #sqlserver #dev #database