instrumentation-pg: operation name should be trimmed

[jkwatson]

What version of OpenTelemetry are you using?

    "@opentelemetry/api": "^1.9.0",
    "@opentelemetry/sdk-metrics": "^2.0.1",
    "@opentelemetry/instrumentation-http": "^0.203.0",
    "@opentelemetry/instrumentation-express": "^0.52.0",
    "@opentelemetry/auto-instrumentations-node": "^0.62.1",
    "@opentelemetry/exporter-prometheus": "^0.203.0",

What version of Node are you using?

  "engines": {
    "node": ">=16.0.0",

What did you do?

Plugged in the auto-instrumentations, looked at metrics generated from postgresql database operations

What did you expect to see?

normalized db operation names, "SELECT", "INSERT", etc

What did you see instead?

varying db operation names with spaces before or after the name: SELECT, SELECT , SELECT

Additional context

We're using typeorm as well, but we don't have that instrumentation installed.

_{Tip: React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}