.Net: Bug: Postgres Connector create Index failed

[JadynWong]

Describe the bug
If the name of the collection contains ‘-’ it will fail to be created, throwing the following exception.

42601: syntax error at or near "-"

POSITION: 33

To Reproduce
Execute the following code in a database with the pgvector extension enabled

#pragma warning disable SKEXP0020

var kernelBuilder = Kernel.CreateBuilder();
kernelBuilder.Services.AddPostgresVectorStore("XXXXX");

var kernel = kernelBuilder.Build();

var _vectorStore = kernel.GetRequiredService<IVectorStore>();

var vectorStoreRecordCollection = _vectorStore.GetCollection<string, KnowledgeRecord>("KR-1");
await vectorStoreRecordCollection.CreateCollectionIfNotExistsAsync();

Expected behavior
Collections can be created successfully even if their name contains ‘-’.

Platform

• Language: C#
• Source: Microsoft.SemanticKernel.Connectors.Postgres v1.37.0-alpha
• AI model: OpenAI:text-embedding-3-large
• IDE: Visual Studio
• OS: Windows

Additional context

indexName needs to be wrapped in double quotes.

semantic-kernel/dotnet/src/Connectors/Connectors.Memory.Postgres/PostgresVectorStoreCollectionSqlBuilder.cs

Lines 146 to 151 in 892c206

	var indexName = $"{tableName}_{vectorColumnName}_index";
	return new PostgresSqlCommandInfo(
	commandText: $@"
	CREATE INDEX {indexName} ON {schema}.""{tableName}"" USING {indexTypeName} (""{vectorColumnName}"" {indexOps});"
	);