Thanks for all o/
On Thu, May 7, 2009 at 9:14 AM, Jasen Betts <jasen@xxxxxxxxxx> wrote:
On 2009-05-06, Anderson dos Santos Donda <andersondonda@xxxxxxxxx> wrote:
> --0021cc022382dbd1bb0469443c6e
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
what format of pg_dump?>
> Hi o/
>
> I have a table with 2000 names and emails.. and I did UPDATE list SET email
>= '' without the WHERE and now all rows is null in column email..
>
>
> I have a backup made with pg_dump.. is there a way to restore only the email
> data?
If a binary dump use pg_restore to restore the table you want to a
scratch database then use dblink or copy to get that into a temp table
in the database you want.
If a text dump use sed (or an interactive editor) to extract the table
data you want, load it into a temp table
finally do an
UPDATE ... FROM ....
to fix the losses.
I had to do this a few months ago.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general