ConduitIO / ConduitIO/conduit-connector-postgres

Feature: use PostgreSQL format function to sanitize identifiers and literals

Open
#158 5 comments 0 reactions 0 assignees View on GitHub
feature good first issue
Dominant language
Go
Stars
19
Forks
12
Avg merge
12h 20m
Merged PRs (30d)
5

Description

### Feature description

Identifiers and literals are not fully sanitized or escaped. This can lead to a connector error.

Use PostgreSQL format or quote_ident function sanitize these. It allows for a full query or an individual string.
https://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-STRING-FORMAT

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the connector's query construction and the code paths that interpolate identifiers and literals. Read the linked PostgreSQL string-function documentation, then verify that all relevant values are sanitized using the appropriate PostgreSQL formatting or quoting behavior and that connector errors no longer occur.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
backend, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.