I’m working in WPF with C# and Postgres.

I’m working in WPF with C# and Postgres.

I am having trouble figuring out how do I connect to a JDBC AWS database via C#. I installed the library Npgsql but does not seem to work if I put the JDBC URL I have as the Host. I know JDBC is Java so not sure how to do this with C#. In DBeaver I have setup PostgreSQL driver then I have selected Connect By URL. The URL has the address “jdbc:postgresql://ma-aurora-postgres.cluster-dssss.us-east-1.rds.amazonaws.com:5432/mydb” Authentication I have Database Native selected and use a service account username and password.

I am having trouble figuring out how do I connect to a JDBC AWS database via C#. I installed the library Npgsql but does not seem to work if I put the JDBC URL I have as the Host. I know JDBC is Java so not sure how to do this with C#. In DBeaver I have setup PostgreSQL driver then I have selected Connect By URL. The URL has the address “jdbc:postgresql://ma-aurora-postgres.cluster-dssss.us-east-1.rds.amazonaws.com:5432/mydb” Authentication I have Database Native selected and use a service account username and password.

I have a small application which I have build into a docker container, run in K8S and read from a postgresQL DB with Npgsql.

I’ve been reading some stuff about postgres extensions, and I’ve got some interested about writing my own extension in C to attend a demand from my company.

I’ve been reading some stuff about postgres extensions, and I’ve got some interested about writing my own extension in C to attend a demand from my company.

in postgree, assume I have a tmp table, which is the following schema