does postgresql 10 have something similar to sql server's set identity_insert

From: john snow <ofbizfanster(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: does postgresql 10 have something similar to sql server's set identity_insert
Date: 2018-05-31 09:15:29
Message-ID: CAE67tvV54+CQ2HS=G8FbYhjrfaz-0g0Jvv_vu741RbJSCvceVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

to temporarily allow explicit values to be inserted into the identity
column of a table to facilitate the generation of test data from
application code?

using sql, i know it's possible to issue INSERTs with OVERRIDING SYSTEM
VALUE clause to fill identity columns with user-specified values. but i'm
using an ORM (object-relation mapper) Framework from Microsoft (Entity
Framework Core 2.1) and a C# test data generator library, and i'm
generating "data aggregates" that have foreign key relationships so it
would be a great convenience if I could save test data with known primary
and foreign key values to the database as this would make it easier for me
to make assertions about my data.

ideally, i'm looking for something like this:

myDbContext.Database.ExecuteSqlCommand("..."); //ask postgresql to allow
explicit id values for inserts from here on
var testData = CreateTestData();
myDbContext.MyEntity.AddRange(testData);
myDbContext.SaveChanges();

thanks in advance for any tips or help!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Laurenz Albe 2018-06-01 08:27:29 Re: does postgresql 10 have something similar to sql server's set identity_insert
Previous Message David Rowley 2018-05-28 01:42:06 Re: UNION but with excused columns