Re: Restoring 2 Tables From All Databases Backup - Mailing list pgsql-general

since this is a plaintext file, not a custom format backup,
you unfortunately need to extract portions of text using some editor or program...

for this kind of work I would recommend Perl or Awk.

below is my "first shot" - thats incomplete (no restoration of indexes/sequences):

gunzip -cd all.sql.gz | awk '/^CREATE TABLE mytable /,/^$/ { print }; /^COPY mytable /,/^$/ { print };'

which does print all lines from CREATE TABLE mytable to next empty line, and all lines from COPY mytable to next empty line.