Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkaRt-0004I9-UJ for pgsql-general@arkaria.postgresql.org; Fri, 07 Apr 2023 00:59:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkaRs-0003lV-F7 for pgsql-general@arkaria.postgresql.org; Fri, 07 Apr 2023 00:59:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pkaRr-0003lM-Lb for pgsql-general@lists.postgresql.org; Fri, 07 Apr 2023 00:59:28 +0000 Received: from sonic319-21.consmr.mail.ne1.yahoo.com ([66.163.188.83]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pkaRk-0006xe-TL for pgsql-general@lists.postgresql.org; Fri, 07 Apr 2023 00:59:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1680829158; bh=uNW/hIwdjlKIEyHelvbgKf1wK2BC/xfSmHTjWsDdICo=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=m5ESHxueJfbZY/J+bd9Dbrn5S4v3NtNBt3qjmKwYZ81ywa4DC2ytvD4bCDABK+u3jgyimBTMbSWp/abR0AUXZclXS/lkLJ/fus7s0yhCdQT9nTZSu/ZoMJEZ2QQR66Zi/ArdMYymFS7hj7Ndh1HbueHUooul0/ukkpJwxyaJau9rBErdOr5P5N6n0xi4a2wmctOW6cln3IxnFRY705k2p7cRvhrO7C0wJUvtH3Hg93YRMM5q1KOpq4g9F8+E7Ggz4TqTewgAfgCFkq4LV/pe7vsyyaMTPsskpuapK6DZzbC3EeXQYCs0XFV8rBtm8m85kIl8C2P/wYVGQX52cbOdgQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1680829158; bh=+U9XK+ngDExHStfuBBn8M+0ySOA4kLnGNflMMFFbzZY=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=XxLJcC0ac8Sw7S4qgkAm65tpV9l9i49DUyCrmXacgdQWVz9L8zld6aMJCsFwcX+IU6LmVM0wlxIkz3MFgdrbVQF++f6uIXTpNmhK98m+kUIMTnVhPHyXz/sjhmztCs6zni4LdElSSReK5zhcJ2kTJo32KKFhL5OZpPDCFQ62vhdeMcqWIpgftRv0IBMoX+e/sMeP7V61JznuXcmbmpNLUtQNMaowsOzBchMyPLEcJZPo2/Lydkcl9VWBZU/JRI6H68rmpkuAlQFPX9OSHq4y5itFsv0YGo3o0D2hLmKzfKUi6ViV1JTjzuQ6HKQLnCf5V+Y1mZqLF3g0IZkTk4x1zw== X-YMail-OSG: mvo6yqYVM1lJszk_1k6SkqqKWyavZZmCNcObPVkGXIVW425fI0tqK7R5wtHDz99 e5ovkJeq3GhZR8Lek_E1sNzHkfIcDa1Zb5mnwPaf.wlTKQ8tteGvaKY84DtbwA5DX7Db6qXRlthe IMUeBXLfGSuNIYoEazM4WCK7D6NIBgOodJf.JfIKdW41x4LUyx2Z2tmLkGsMgsVNQJLjPmgxtXil e0ywRsfycVhNcXgMOEd31gHGv75laauZnAkcqWAwFDvLWJdJuSuXUGVevFzYAj6RbEnQUtAOOeiW 6Tl4gW65MuTahHg3DVSbH7yKrCaZTbleLtUOiLegYbpsb4vBMMgLvXbPN4j0gJPgeYby5.4lTs4a xkSw.7P_wZIPYTYuTMJzsJ.mXKhh5i29UTR22XX_JT4Wrgh1UU5kCDmpQ5ga9_FkgHYk33_VVI1_ hPgB15G0xrG2XOUcEM97xcMMExaSubW3DItwcUAltjS570Qzv1Z1gBlGWHM.jkAex3.KM7gI2btQ Rqb2FixYPK2BLXQOlSI2omdy.y0ctJIhsQ1QhVdfWcsrm9VxP.a0VqSNdXxV7qie.Mx9bQSiwnGJ Y3KgJWHyneHBqg1FpjHiAiIa2qSrOSSsYS5zvlGHxe.l.e7FrLrwM7Hq5hREUtp6l26g4sMDo584 3W.Wwpt9XiNrwBJFkXezR48Q9OfAORbLaz3qUOhl9FUGh2KdXmK4ppPvFf_HrHembu4XHA8_udaM au_0jIhCROza56JaOeHCI5MSBHFm1doRu7YfGJP2L0iouOg3BDfK4m0GwEN9_ATrAlO7yWnDCxoh TP8Wy1c6m5vgcxTIuWBsRnFSwl_p0i8XOC08g.N_e0RUc5kBI2uqn9YVW_psPU11SOYkMu5GVR.F CIQlrIiIwJRlEx_3GwUkb6NO1PZnbwGj591NQ2_vf8uMYiTJx1jOnqKNBPJLWpSnReeFcDqv5O7W x0xk4eUQUUECrcy3KNj653Iqd9I5Qwf8xO9Fbvb06VmXFXx_fBwhr8oaOjgM5UntBcel7.XCHdYA 1g89fMEa0VLPkYirsMB.G4cNZSoAOXDEPV9DB6ERFtaa9CZ7LhRAPET6ZRxwEn1JWTWgsnWdlGxe WpHR8AyI27e_v3UGAlmYNLYMJYPRiTw02aq5_WhABlimalGkcs.IqmQwokgAzPaVsNErlRtV_y31 kIQAIHXf_Sh1SbBRJhBLgWldexL1y8.dUGmxQy1UL_276H4Vgel8emewyNVTiF.NFLH2ilPh5k8P ztY3E25ZHZOR1FziM4Wh3Ta2kzO9e43_4aRrf7SL8UsPq.rTbsO05HTQfC1ZeDCWB8Cva8xp0er4 20lJNxTj736F2RqSnHHaMoi3_7NFtxQvsMpASg64qQ9Vahuy5_clysH0tUqEs3fgIoxM8ubr80Xg pO0QZLvw_rz9gB43AZPtz_rb0nqPoHhqxeSwLFLQndr9LWAsivmCsxftUEPf_3fdsF3Mt7eT8t3u 2Xd8GVxuGeMY0AO0q5ZdTGJOEwXG2mnZcZqKdQOf08LS1zwyy4bDrUkv8nUlOlOeToqcEg0LHMQz Z1oB7gR0VYzrJsO6_dcE9cwjMp3yk1QRTMeFCpyEbsqgndyBQVgqj5RvgXnois5CPeOexzfx5tsR o5n2C_x0XSkMdVZprVGl.oRw8fCS5aMA7AxU2eN0dUwlfUu7yR1amOf9y3E682bvSaHMjyTGLAjd KBsDOVtsgkGQpKK0OWmXSGSdRVZAv4VtzBGWoQVxxq51Mh.UHiWPgUQgpzGxntv5RLDx_R0iTsqP QRpdKLIy4fubj5U5wDnrEn8sv3d0qBIbmulQYcZClspv1R5Dzt_0unXms6od1S5Dsf9bgtp0uLrc VNCn9QDk_RG1XvUIZqzzSXPrHRjlevVcTkz5fkLaQ2vmbHp_BxMmHpLMOFNH1Z37G3eHjzSvdCkj .ouWzaQveq_S97PN3aDFzJcYGExSfCQpARxPR6g6WzTq7g0cnIllUDrQU2oefdoOWqVr_EQQmt99 y09BKnF2GH39ixky8xkrxbycUC9jFPi_DDDZwaaydpwvWjy27tQNoykRmdgpQMhB4NZ324ZnxDW3 0FkdeiVFp6zHzCuMeaximA63jlV.HOft43qUJ2xm2JekXun7qG7_vUK1Ph7.vP1.YOPx1VzRGmoW .IHgorC5SS32e9tCCyw16Q3_PrUrTTngK05rXvGsl3IJTYRXVdN4fzXYNZrEMRVAuMb.JLtuHK5B NGXRzhYJ0IxaXwiDIhZI- X-Sonic-MF: X-Sonic-ID: 33b0dad2-5b68-4de0-8ab5-82dbdc66f0b5 Received: from sonic.gate.mail.ne1.yahoo.com by sonic319.consmr.mail.ne1.yahoo.com with HTTP; Fri, 7 Apr 2023 00:59:18 +0000 Date: Fri, 7 Apr 2023 00:59:12 +0000 (UTC) From: Brent Wood To: pgsql-general , Atul Kumar Message-ID: <694694106.675857.1680829152749@mail.yahoo.com> In-Reply-To: References: Subject: Re: Backup schema without data MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_675856_1159861216.1680829152748" X-Mailer: WebService/1.1.21365 YMailNorrin Content-Length: 3484 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_675856_1159861216.1680829152748 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Looking at the result of: pg_dump --help Usage: =C2=A0 pg_dump [OPTION]... [DBNAME] ... =C2=A0-n, --schema=3DPATTERN=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 dump the specified schema(s) only... =C2=A0-s, --schema-only=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 dump only the schema, no data...=C2=A0=20 So: pg_dump -s -n It works for me... Cheers Brent Wood On Friday, April 7, 2023 at 12:40:58 PM GMT+12, Atul Kumar wrote: =20 =20 Hi, Please help me in telling that how I can take the backup of one single sche= ma without its data using pg_dump utility ? So far, I could not find anything suitable for doing so. Regards,Atul =20 ------=_Part_675856_1159861216.1680829152748 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Looking at the result of:

pg_dump --help

Usage:
  pg_dump [OPTION]... [DBNAME]
...
 -n, --schema=3DPATTERN      = ;   dump the specified schema(s) only
...
=
 -s, --schema-only       = ;     dump only the schema, no data
...=  


So: pg_dump -s -n <schema> <db>

It works for me...<= /div>


Cheers

Brent Wood


=20
=20
On Friday, April 7, 2023 at 12:40:58 PM GMT+12, Atul Ku= mar <akumar14871@gmail.com> wrote:


Hi,

=
Please help me in telling that how I can take the backup of one = single schema without its data using pg_dump utility ?

=

So far, I could not find anything suitable for doing so= .

Regards,
Atul

------=_Part_675856_1159861216.1680829152748--