Received: from m9.boston.juno.com (m9.boston.juno.com [205.231.100.195]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA40478 for ; Fri, 15 Oct 1999 08:55:23 -0400 (EDT) (envelope-from jcc2@juno.com) Received: (from jcc2@juno.com) by m9.boston.juno.com (queuemail) id ENYMDE87; Fri, 15 Oct 1999 08:54:50 EDT To: pgsql-sql@postgresql.org Date: Fri, 15 Oct 1999 08:54:01 -0400 Subject: HOW DO I... Message-ID: <19991015.085403.-768299.0.jcc2@juno.com> X-Mailer: Juno 2.0.11 X-Juno-Att: 0 MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: 7bit From: John C Cusick To All, How do I select from one table into another table that already exists? In other words, if I do a: select * into tblB from tblA where attrN like 'xxx'; and both table structures are identical I get a ERROR: Relation 'tblB' already exists If I : select * into table tblB from tblA where attrN like 'xxx'; I get the same answer. I also tried using 'update' So, How do I update a smaller table from a larger table? For those who wish to know, This is a large parts database that is updated monthly and I have divided it into smaller subsections for quick access through a web-based interface. Searching the original table is much too time consuming ( over 130,000 part #'s with Specs and Descriptions - all running on an ancient 80386). And I would like to avoid updating the smaller tables by re-building them from scratch. Thanks for your time, John C. ___________________________________________________________________ Get the Internet just the way you want it. Free software, free e-mail, and free Internet access for a month! Try Juno Web: http://dl.www.juno.com/dynoget/tagj.