Don Bloomfield IsDon

Working to land a role as AI / Data Engineer, experienced full-stack engineer, with User Experience background.

3 followers · 3 following

Defence Contractor, and Sole Trader (supporting current clients only at present)
Sydney, Australia
20:29 (UTC +11:00)

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

1 file
5 forks
2 comments
31 stars

michelmilezzi / idempotent_script.sql

Last active October 23, 2025 06:41

A simple script demonstrating PostgreSQL idempotent capabilities. You can run this script as many times as you wish (it will not give duplicate object error or similar).

	--Table
	CREATE TABLE IF NOT EXISTS person (
	id integer NOT NULL,
	person_name character varying(40) NOT NULL,
	updated_date date,
	CONSTRAINT person_pkey PRIMARY KEY (id)
	);

	--Index
	CREATE INDEX IF NOT EXISTS idx_person_name ON person (person_name);