Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A08274760DF
	for <pgsql-sql@postgresql.org>; Fri, 17 Jan 2003 18:59:30 -0500 (EST)
Received: from mta4.snet.net (mta4.snet.net [204.60.203.76])
	by postgresql.org (Postfix) with ESMTP id 26AFB477507
	for <pgsql-sql@postgresql.org>; Fri, 17 Jan 2003 18:51:24 -0500 (EST)
Received: from pop.snet.net (pop.snet.net [204.60.203.72])
	by mta4.snet.net (8.12.3/8.12.3/SNET-mx-1.2/D-1.1.1.1/O-1.1.1.1) with
	ESMTP id h0HNojDK015042
	for <pgsql-sql@postgresql.org>; Fri, 17 Jan 2003 18:50:46 -0500 (EST)
X-Originating-IP: [64.252.95.167]
X-SBCIS-MTA: [pop.snet.net]
Received: from monet (167.95.252.64.snet.net [64.252.95.167])
	by pop.snet.net (8.12.3/8.12.3/SNET-pop-1.2/D-1.1.1.1/O-1.1.1.1) with
	SMTP id h0HNpGc4026087
	for <pgsql-sql@postgresql.org>; Fri, 17 Jan 2003 18:51:17 -0500 (EST)
Message-ID: <001601c2be83$59ebe420$5301a8c0@monet>
From: "Wei Weng" <wweng@kencast.com>
To: <pgsql-sql@postgresql.org>
Subject: Can I do this?
Date: Fri, 17 Jan 2003 18:51:27 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0013_01C2BE59.70E81560"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/282
X-Sequence-Number: 11147

This is a multi-part message in MIME format.

------=_NextPart_000_0013_01C2BE59.70E81560
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I want to select some data out of database A, and insert them into database=
 B. Is it possible to do in one SQL query?

Thanks

Wei

------=_NextPart_000_0013_01C2BE59.70E81560
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-125=
2">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>I want to select some data out of database A, and inser=
t them=20
into database B. Is it possible to do in one SQL query?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Thanks</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Wei</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0013_01C2BE59.70E81560--