Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id C30E6632739 for ; Wed, 6 May 2009 09:34:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 88407-07 for ; Wed, 6 May 2009 09:34:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.26]) by mail.postgresql.org (Postfix) with ESMTP id CACDF632656 for ; Wed, 6 May 2009 09:34:26 -0300 (ADT) Received: by qw-out-2122.google.com with SMTP id 8so41843qwh.61 for ; Wed, 06 May 2009 05:34:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=IqBrRiav9P9Lvho27SbqeX6u9lE/oQLqBuzL5hnmMtM=; b=mwv5r62h0hJNhxpgYKt93sEeZFjnxc2G3tqKhfHdA8h2wjq7FRzm5hnTN1xkcmAP40 0rlJq0UeK3Kf37gGd8hKwotxL7vIMrmpfiT/NoGq2mu6e1JUzck4vHZK97QACQRXnUAN 4TN5/ZqPgNuvpSL5ZKBEwxa6a7Bv4KeBWsDLI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=c0vXyU834SyiN/L7lHMDwHsGC3umYYgTRHsjlgXEYCFY0ZPXj6mt/n5u0qT/CfiM9o gMkIa6W6s8AeGn6F/nMdIuWTGaa/J1MpVYnD1VCMXHAkGmdEWN7RiQ6xh5FV/ciG56B8 96VtWqXwb0C8hE7cte5aEEHiFyxapigyoDJSM= MIME-Version: 1.0 Received: by 10.229.74.212 with SMTP id v20mr132895qcj.16.1241613265419; Wed, 06 May 2009 05:34:25 -0700 (PDT) Date: Wed, 6 May 2009 20:34:25 +0800 Message-ID: Subject: how to select temp table From: liuzg4 liuzg4 To: pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary=00163646c004a2407404693d9d15 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200905/204 X-Sequence-Number: 147342 --00163646c004a2407404693d9d15 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit ver 8.4 i create two table with same name named 'testtable' one is temp table i select * from testtable then this table is a public or a temp ??? drop table testtable then is this table a public or a temp? i test ,it drop temp table fisrst! so am i must show public or pg_temp_1 when i has two table with same name !!! --00163646c004a2407404693d9d15 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable ver 8.4
i create two table with same name=A0 named 'testtable'
one is temp table

=A0

=A0i select * from testtable
= then this table is a public=A0 or a temp ???
drop table testtable=A0
then is this table a public or a temp? i test ,it drop temp table fisr= st!

so am i=A0 must show=A0 public or pg_temp_1=A0 when i has two table wit= h same name !!!
=A0
--00163646c004a2407404693d9d15--