On Monday, August 12, 2024, Wasim Devale &lt;<a href="mailto:wasimd60@gmail.com">wasimd60@gmail.com</a>&gt; wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div dir="auto"><br></div><div dir="auto">Please let me know if the below option persists while using pg_dump command:</div><div dir="auto"><br></div><div dir="auto">-t table_name --exclude-column column_name</div></div></blockquote><div><br></div><div>No, there is no option to dump a partial table, rows or columns.</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div dir="auto"><br></div><div dir="auto">I just want to exclude this in the dump file as it is of 99GB but I want the other data in the same table which is of only 22MB.</div><div dir="auto"><br></div><div dir="auto">Please let me know any work around this.</div></div></blockquote><div><br></div><div>Write your own copy command to export that table’s contents.  See the —snapshot option.</div><div><br></div><div>David J.</div><div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
</blockquote>