airbytehq / airbytehq/airbyte

Source PostgreSQL: Columns are not in Order

Open
#24,635 2 comments 0 reactions 0 assignees View on GitHub
area/connectors community connectors/source/postgres connectors/sources-database frozen releaseStage/ga team/db-dw-sources type/enhancement
Dominant language
Python
Stars
22.1k
Forks
5.3k
PR merge metrics
PR metrics pending

Description

## Tell us about the problem you're trying to solve
PostgreSQL Source doesn't generate a destination catalog, in which the Columns have the same order as in the original Table. The data however which is in the form of an `AirbyteRecordMessage` has the correct order for columns. This leads to inconsistencies when replicating the data from a PostgreSQL to a destination.

## Describe the solution you’d like
The Catalog generated by the PostgreSQL source which will be used by the Destination should have the columns in the same order as in the original Table.

## Describe the alternative you’ve considered or used
None.

## Additional context
None.

## Are you willing to submit a PR?
Sadly no. Im not proficient in Java.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.