X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F16C79DC868 for ; Wed, 22 Feb 2006 16:57:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79712-02 for ; Wed, 22 Feb 2006 16:57:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from CORREO.correolux.com.mx (customer-200-79-53-218.uninet-ide.com.mx [200.79.53.218]) by postgresql.org (Postfix) with ESMTP id 389829DC83A for ; Wed, 22 Feb 2006 16:57:03 -0400 (AST) Received: from 192.168.7.58 ([192.168.7.58]) by correolux.com.mx with MailEnable ESMTP; Wed, 22 Feb 2006 11:56:59 -0600 Subject: Update in all tables From: Judith Altamirano Figueroa To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary="=-8cbtgGHEqVcAQ/p2gyd0" Date: Wed, 22 Feb 2006 11:59:06 -0600 Message-Id: <1140631146.5580.5.camel@Desarrollo> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.119, HTML_MESSAGE=0.001] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/272 X-Sequence-Number: 24282 --=-8cbtgGHEqVcAQ/p2gyd0 Content-Type: text/plain Content-Transfer-Encoding: 7bit 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!!! --=-8cbtgGHEqVcAQ/p2gyd0 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit     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!!! --=-8cbtgGHEqVcAQ/p2gyd0--