chore(instrumentation-pg): have @opentelemetry/semantic-conventions package dependency with caret (^) version to sync with other instrumentation packages

chore(instrumentation-pg): have @opentelemetry/semantic-conventions package dependency with caret (^) version to sync with other instrumentation packages #11058