Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trhh0-007n4i-VI for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 18:17:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1trhgv-00GWg2-2S for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 18:17:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trhgu-00GWfu-Jh for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 18:17:28 +0000 Received: from mout.perfora.net ([74.208.4.197]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1trhgq-0025HY-1J for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 18:17:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1741630643; x=1742235443; i=agents@meddatainc.com; bh=zoUDhKTkb4x9lwkmjepSPtTgWath2IUSxU8tSQ5Qfhk=; h=X-UI-Sender-Class:Date:MIME-Version:Content-Type: Content-Transfer-Encoding:Subject:To:From:Message-ID:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=pDkuuQquvNNtVEiOXMq0LdJd3TAZAYOwJ0fKcqu2qvYpY48WD+f2cmU+uGxanjYm K5chWVm47CUsmGfUlSFltS+H4Sz5xrmEL0uwc4z5e3R1m0qbQ1+mDp0tY2c9uRa1m ajlwOnW4hDwaktbxT8yGUPBtMM9r8e4sulN9okDdAuNdtwFYq8A2q6NcOWGMqAXRj KqH1CbOMe6C0ATMWBIbZuJae1bFuu4ftmG8ACGAv34udL/Hd4Skz8ZTeNEpL1hLM7 UwYwOIERF5vYDfldM+aGq4nSWaLQ4rXhVZBr6Vm6xHbpURauCjcHV+ltlRcI8hnew K02rC826Je6n/Xz4dg== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.106.147] ([96.245.190.98]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LrM66-1t6ZaA2moW-00xYNe for ; Mon, 10 Mar 2025 19:12:18 +0100 Date: Mon, 10 Mar 2025 14:09:15 -0400 User-Agent: K-9 Mail for Android MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Creating files with testdata To: PostgreSQL Users Mailing List From: H Message-ID: <84A5765B-1D3C-485B-B852-99D63D53963E@meddatainc.com> X-Provags-ID: V03:K1:m984EQRn6Qc2EI0YAhGm6fw46Yz1XmUMSQgW54yEpegmHsjas3w dq+QVMHkB9ET08/dZtSCcumIJFjw7jNA79CwVakBEgI4nf4fBcIqDNVd6cWAUdIOlbPKkfV QfhU1zs66b6CFWnJO9j38/suIpOK2ROmcgBMmNYZETq7e8tmqCkuTLN5N6g8Rg1IceGlU79 dIiDDWSgPnRwvFe/feSnA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:D1CS0WZv1/w=;Td1MBlqjlltiU4ZaCdx0n6240oW zi6/lw6pH3CbRrItHxfBDa0W4HTNjvkL8MkLv/GjPdjXtgwelQz6YTsiHJSnvl5+hfQbKGME3 T2uwUHrm3ocP+QUtA13p6EW/8jp+H8J4elDBR6/ttDIkZHoaY+j5FSiw91XNse2+sdt4HpNyi CavmF5UftbFyUHwMiZpfoH1WDjJhdfTtFWcZNHUbgMYaMLVQ83pvG0RtdquLxowiAQW7n/LcC bCg/EL0xvsWEgJl9lh+HpQk5evOTJ08jE9AMbWd8Hr6mkIh7Ivh1zj+jQWVF5Si6Cd5uhKVTZ oROzdyNY134VUQz4TVoHXmA8i+V7tDr66li0No7ktU10prQdtQKpxSyuGqRF5K+olVx6ugXS8 /5nGS5HTm65Y9kXk+puRK+38TY1Opv4yrwytFGSvjDOZNdYthlOsZen47g80R+UF90JdjzT7V PgwfCGqR2sW+3sxdnXKdoAaiJNtj4Ffj6Hk32gklAiMIAcWU1MWmXiuyxw16patbeA9L2QgXd 0XaUVdt3Q557oEbFE3RXF7UNDe6QXQ1X3kSO6nNi4XwJeVO1EIJbxygyJA2pHE13NsySiOiaO Qij791J1IlN09tNGI0SSK8ko8G2zhuzdPw8LWyYEmiBpcVUcbp+92ryhFsyRQRLrT3VdZ49Cf oAnWTkoPIqMMmIUg8hY8j/JzHcYFEeTtzHQBnX90nr38TDUrqLTOaKoujf8V2TCt7dSfGBzeN xW6qG1vb7cvD0PkAdKqsk5SSgLgCFUvQ5nJmeZQHn7jv3+8sCyIhILv2nUMeMW/lfs/kLp7kV fSBp8GlTzZoXa0EP/8f9hyXe38Iv8g60O3TY6jVwGieb7PkQuomDI51pdv8xWQECukkHcId2f bO9nuI/o2ESCvkPTzcH+e7ElQMAdYZFBEQ3qYLue1Z09gxhi2LiYbh9R+jStHgR+Y7uubqzUp AVOwL6PzbUQhq+MmcFIrJZDXEnGHlzGAGUgPlSDYTMSshrDJUraBpcNW5Cmf5GzPwf/HwYjID MGPjw8H9FDvnHTjxG6atx5GBwea2t3+A87f9ysHpvNymmgm0rs3I3qz2Wsh78T4LHuVIzWr/S VBuk5wQoKaqp61bzf3yKN4SIK6WpZkX9UstH/1Q4doSxlLKfmxnrI4dghWnQbf2LIFSonxx8H +75/bLhPSWttI5Oro7zqXtefenbBRIf/o1vxyoDzuVJHACVUJcBd5CP2xUVlKTxg2mvOdneiG +tzL7hBbVhBEzYy8AlVNSilXYaAd8Cm1GUsGjObjPxU+DJrEc0S6Z6lNVf90EQyFR80es667v RC/fDspxuLheaUhRynA+sITlgGaKuXmF9odUS0S78iFlEGOI8UvVaoB8jybmznZRJhy List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I am developing a complex multi-tenant application in postgresql 16 in Linu= x=2E During the development I would like to be able to enter test data into= various related tables at any given time for testing purposes=2E While this can certainly be accomplished by predefined CTE INSERT statemen= ts in an SQL file, I would prefer something more flexible=2E I am thinking = of using a markdown file as a source for these CTE INSERT statements=2E Spe= cifically, having a certain structure in the markdown file where a given ma= rkdown heading level, bullet level etc=2E would correspond to specific tabl= es and columns=2E After entering my test data into the markdown file for the given test scen= ario, I would then run an awk script or similar to create a SQL file with t= he various CTE INSERT statements=2E Howevever, it gets complex since I need= to handle 1:N relationships between tables in the markdown file=2E=2E=2E I hope the above outline is understandable and am interested in comments a= nd thoughts on my above approach=2E Thanks=2E