Search Results

Here are three major points you need to understand about object ownership: Only a superuser or the owner of an object (table, function, procedure, sequence, etc.) can ALTER/DROP the object. Only a superuser or the owner of an object can ALTER the own...

.NET EF Core 6 made a breaking change to how DateTime is stored in PostGreSQL. This article explains some of it and the workaround: https://github.com/npgsql/efcore.pg/issues/2000   To enable the workaround, add this to the Configure method of your Startup....

Remote Access For accessing the postgres database from outside the host or from a docker container on the host, you must setup the Postgres instance to listen on a network adapter other than localhost. To do this, locate the postgresql.conf file in: /etc/pos...

Here’s a list of .NET datatypes, and how best to store each one. .NET Datatype PostGreSQL DataType datetime (UTC) timestamp without time zone Guid uuid float real double double precision ...

Here’s a means to insert multiple records in a single insert call, which is about 40 times faster than performing an explicit insert for each row. We will leverage the BeginBinaryImport method on the database connection class of the NPGSQL library. To make t...

Here's steps to work through, to ensure remote access to a PostgreSQL instance. Check PostgreSQL is Listening on All Interfaces From a terminal, open the postgresql.conf file, with this: sudo nano /etc/postgresql/<version>/main/postgresql.conf NOTE: Replac...

Adapted steps from here: https://www.c-sharpcorner.com/article/crud-operations-in-postgresql-with-ef-core-and-asp-net-core-web-api/ https://documentation.ubuntu.com/server/how-to/databases/install-postgresql/index.html Download PostgreSQL can be downloaded...

Access Postgres as SuperUser Use this terminal command to access the local PostgreSQL instance as the postgres user: sudo -u postgres psql Setting Postgres (Superuser) Password Normally, the postgres user (superuser) does NOT have a set password.This is be...

In order to easily stand up a Postgres database for unit and integration testing, we need a class that can encapsulate the effort, to an easy call surface. Below we have a helper class that will manage the life-cycle of a test database, in PostgreSQL. Given ...

Here's a list of what datatypes that Entity Framework uses to store .NET datatypes in a couple different database engines. .NET Datatype SQL Server PostgreSQL SQLite Comments bool bit boolean INTEGER byte tinyint smallint (Postgr...

Here’s notes on how to create and manage databases with OGA.PostGres.Lib. This applies to use cases for: Standing up a temporary database for unit and integration testing. Creating live database tables with compatible column types for storing class ...