Update in all tables

From: Judith <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: Update in all tables
Date: 2006-02-22 18:08:48
Message-ID: 43FCA8B0.3050803@correolux.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello everybody I need to update a field with the same value in the
tables of my data base but this field exists in almost all tables and
has the same value, I don't want to code a script, so my question is if
there is some way to update that field with a query and affects all the
tables that contain the field?

Thanks in advanced, regards!!!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Janning Vygen 2006-02-22 18:33:36 Re: Update in all tables
Previous Message Mario Splivalo 2006-02-22 18:02:30 'locking' the SELECTs based on indices...