mcarman
/
resequenced_pgsql
1
0
Fork 0
Code Issues 0 Pull-Requests 0 Releases 0 Wiki Aktivität
Executable that will resequence ids in all tables of a postgres database built with .netcore 8.0 Cross Platform Compatible
Du kannst nicht mehr als 25 Themen auswählen Themen müssen entweder mit einem Buchstaben oder einer Ziffer beginnen. Sie können Bindestriche („-“) enthalten und bis zu 35 Zeichen lang sein.
7 Commits
1 Branch
1.1 MiB
 
 
Branch: main
Branches Tags
${ item.name }
Erstelle Branch ${ searchTerm }
von „main“
${ noResults }
resequenced_pgsql/DBResequencer.md

781 B
Originalformat Permalink Blame Verlauf

Postgres Database ID Resequencer

resequence_pgsql is a command line utility to resequence ID’s from the last id entered so you are not violating primary key constraints in the database after initial seed data or migrated data is inserted into the database. This is for Postgres only through an ssh connection.

Installation

resequence_pgsql requires dotnetcore v8.0+ to run.

Download the Project

git clone https://cvs.prelub.com/mcarman/resequenced_pgsql.git

For production environments...

dotnet publish -c Release -r <RID> --output <output directory> resequence_pgsql.sln

List of RID’s can be found here.