On 2009-05-06, Anderson dos Santos Donda <andersondonda@xxxxxxxxx> wrote: > --0021cc022382dbd1bb0469443c6e > Content-Type: text/plain; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > > 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? what format of pg_dump? 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
