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 1qxCsi-00GkgW-Sh for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 20:59:37 +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 1qxCsh-009IrY-Eg for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 20:59:35 +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 1qwlW6-004lIa-NS for pgsql-general@lists.postgresql.org; Sat, 28 Oct 2023 15:46:26 +0000 Received: from sonic301-2.consmr.mail.bf2.yahoo.com ([74.6.129.41]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwlW3-003Oe8-E8 for pgsql-general@lists.postgresql.org; Sat, 28 Oct 2023 15:46:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1698507979; bh=vrIj3KCeIMeoVcqJi1YzkwXu/iP1HcEiz/YTVfq4oiY=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=HSq2KIRQbsAkegl1JTl1rA7OuT4SvsKnSVg+vyBfuNTgwKvRNsGRjsWiAxJ5LtBAGecHkR5pAn5ENNGAzKO4XiPiMWKUrcAXxrl81iu3yYoZdlPqpKxozkZkc6pcXSWlOA3n/lB2dyNJtL3jLP2B0zc8JLQGIIfHLA3BvjhgsKvUSGyydceb4117zKYVXwaqEg1w6WbnarMZL8PnRGmlCm8d6SxC0/VuvJSGfzcMaqzmEltbD5haW9ktlMSi7NBvazAaQ7S5EPQ1cy4VEqZwcg9vcQZBQ7Eqq6/4mtvmv3xbeCmezpp7sNkkgIJeGpE6xGlY6DaHas2R+sCNZYY7nA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1698507979; bh=IN3bALvbr1+IQfIH/ASQG0RXUxFKCPorLz2/0vn3tng=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=gvTC0t7HyxG8re+tn3+UePKG9oRMrH123ho6EU/LIkh6gtpxiTjnyA9ihVbl48PcjHYUfYwAyVA/y0ft6kiuK/YGmYNItBMA3cuH+qOreIhhGmFXhvkGQWNwnOSzbz96auIxUlt2pr/UmFPm8qDlz1r42vT0W3p8P4S0LYX1OLKeKIIcwFpbTsUE3uOpUUiF2FggvIXtr+dky7+jJ6ogf7TODfUTC1fOAdmAmX42+iizQpKALkc3EsZF400ICYRt4UcpfvjK0qpf6TMQFrtVsZHsa6LIJ7wW79ngcL8ynMd+csMJr1VIquSKTMFhjntmdK9943dpiNEXDJtuCnFoKw== X-YMail-OSG: ayk7uKsVM1kMPkuma75.A1hJG0QYqmB1eXRWgzfZ3PB1PxASa7RltlqQlrgG21C O7t5EJPaQCnBAS1jNoaP5wREi9dqOdlY1QSGNRqoX9kWBR3XSy665VEFEyTmgnRgVsLE3BrytPEW wmhoNlAPSgF9QXBWzkmKUiQyk2EfMvcbAUTzxXp2dcutVdotGcGRXQgTm7wDmNiGA5AjtWJrpSfc LjJ_hQq6C5kfEjKsDgu8GSqHERWyxa17hnKTdgIVK9EDOxIRFgW0U9h.qg5fZYIM9AskIVb11ohq UECdvqX_TFL1QM2KeSyEs8Mo3j5ERH8PiQtCI7ylu7JHuezaVorKm5x0YajkCvK0vIracPBdt0.U 3anMmqqy8I4JS2vf1U_7Z2MxiEd9iTqr0VP1y9.9AbOD.LgjBM73mij5JhSoZqY3ndsXqDFjqmEf WVzFumOGwNTsG2shvQsT.H3ybBgbhJHYa3KnoHfq7hnVNt_fW71I27WwJvZdRuthbg97lodcNUGg De.a8EADAKsp0dAK5GTDp7sxv4Te.3Bd9VtrEIfRjlej08XWtAVs.80_L6FhEH87HNBy1VjG9a1t rj1f2Zq7S1uceQjpPfyz1HVMzxZPFVkX2VIQt7yF1fihlZajviB0VFWhdYHOgZr9vAnUe_nwpQXO qrYTRr5TdrkvhNsmHKQKBHRJ2f1L1iFB5xi.GvSJAlcZcJEybxkf51CxS0R9yrVha7sidCbTpYDe Ff8GLnmqpi2gQBnCeLiQihGrhmlk.XpWGTzvtqaJNn9v4SGCojiTZG.y__qsSD1.OEI4vT0rsiJf yI9hvjlXJAbmRogwFoftcB7q1WnS2tavJOzm.TGc1jCnv3Fwl0L5Utk_PQFBFq7kJMZXh6MCRpuE GHAn3CL49ZDvIWS6SaA020txR_Pu.7K3yRSKWh1ZYttbPW_Mk0hOL39Mey7QbZvv88xrg5EXsdAn pSDdcH0fx5JnB7SK92hFNnw0c11M4pvLR7LMPqCRAvu219IGVtFiOos_d089cl_SCxuvs.8xgzPi 36RpYy3ypTXpGNwbXSx84gyzJAXMfbZeg9XrAcIBl11cHplbXvAZyDQ3oENUfq3Z6OHuVQjR9nm2 gGHmpv0hKsMyTpch_1D_fP6AiGAjI.zKLgfPWLotATrysFSi1f.UBRLYjwdoxzdueJddVSNbvUCh pm6Wml.WbjR0aG9iVd_N48o9ZC9n1sl9Lf9mTnRwx3.xZdS.bktHUDpLgfIA9L.y7RFZER6Tllom mf1pn7nDNykeE5QhvYszkI394YyktIWZWFTLDqFvEEn5Sc0I8X8Y_2QdLoLeUfL8plJFLidfct2y n3FaFu1bf4bYh1dPIi2SfuEDK2ti3pC1_YpuIAxDtMVqiBEABs93CbcEjltuT6UpQkybyPJESGsY PmUw3ZWg1eGW6IR7O2ys1LVjveRlJyXXJiHhlI3ahBBUFVsJk8exLUdkIgBxjXApT3.jy6DR__Hg WKJC_WFGkJQf6NHYnysF46fBWl2uSVNSiF_f4RV0aJO0aYHAn8bFOPlQpJV2FTsmOREA2lirB8RR 4vMQ_AmNv61QTTXTcPEgCwfw9FMriJ8Q1rKcf_CeYEGnOWVblrFJUwpQmwLTd5GK8vH86Mv9Zo1D KlRxDEw.rwzKs46UCFdx8YnEZr6gGUfFBWQN6VuJBAuFPZN6rhjnsaayiW4bGE53846gZHWcV9kP zDpGnCFAJyjcdNmr8GkbWPEl5BgVf5Fk8lJo0zZX2k7m2XSzytxEP0qH0z0tkGcbmhU.zFFA5ibB A4I0oqp.Rt7CZk4eN5iEyzuiyEjJXH3GzhwI7XH34x8zoemfBrTuSiU0aIGxo7Objdd8wTLhUH0T x9kLDRJaYLTTDmGVF2JhdtMQBv75BL98j5uiVKsESj1F9U20FikEUuhYf3R6gornzZzp1_od1ssn 9SV.wHYRxsQQjQoImGFEvO8QipBBb6RpUVszM_e7N1zVXh8fbflnrn9QxImtZn1xxn_Ce0aqxZNr vJMM5em1Vgp3sG1oovH3cSgA3Yo8vPKWwO9wG8DwJIcX_NGTWky2pHJ7.S.9XYiWWMh4bqrNosOE URTOQsXmh8L4PK.yX37wvV2Rfy9Z_.KxRDVzREMgote9ATyy1juyPt_7YECN.uoIsSIbhTW9qgK8 uihM2j_UB6u6a.5mkaLENMG8p5jOg1ggdFadspUbmnq7FapB0yi4- X-Sonic-MF: X-Sonic-ID: 8865c551-9f5a-4901-a6d2-053320cb31cb Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Sat, 28 Oct 2023 15:46:19 +0000 Date: Sat, 28 Oct 2023 15:46:16 +0000 (UTC) From: Ravi Malghan To: "pgsql-general@lists.postgresql.org" Message-ID: <1829482767.120152.1698507976873@mail.yahoo.com> Subject: Differences between database objects (tables, triggers, sequences, functiions) and a sql file MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_120151_828445237.1698507976872" References: <1829482767.120152.1698507976873.ref@mail.yahoo.com> X-Mailer: WebService/1.1.21890 YMailNorrin Content-Length: 1105 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_120151_828445237.1698507976872 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I have a master sql file used to create all the database objects for an application. Is there an application/script to compare what's in the actual database and my sql file and display the differences? ------=_Part_120151_828445237.1698507976872 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
I have a master sql file used to create all the database objects for an application. Is there an application/script to compare what's in the actual database and my sql file and display the differences?
------=_Part_120151_828445237.1698507976872--