Hi,
On 23 January 2013 04:57, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> Is there a way I can extract a single table's schema and data from the
> full backup? If so, I can then drop the fubar'd table and do it correctly
> this time.
You should grep for:
- CREATE TABLE
- COPY
statements and then note line numbers (fgrep -n). Finally, used `sed`
to get the right part(s) of a file (schema + data):
sed -n 'startline,endlinep' dump.sql > out.sql (ie. sed -n '10,1000p')
--
Ondrej