Please let me know if the below option persists while using pg_dump command:-t table_name --exclude-column column_name
No, there is no option to dump a partial table, rows or columns.
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.Please let me know any work around this.
Write your own copy command to export that table’s contents. See the —snapshot option.
David J.