Received: from oxmail.ox.ac.uk (oxmail4.ox.ac.uk [163.1.2.33])
	by hub.org (8.9.3/8.9.3) with ESMTP id DAA96138
	for <pgsql-interfaces@postgresql.org>;
	Thu, 15 Jul 1999 03:42:42 -0400 (EDT)
	(envelope-from moray.mcconnachie@computing-services.oxford.ac.uk)
Received: from heraldgate1.oucs.ox.ac.uk
	([163.1.2.49] helo=frontend1.herald.ox.ac.uk ident=exim)
	by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1) id 114gAC-0006DN-00
	for pgsql-interfaces@postgresql.org; Thu, 15 Jul 1999 08:42:40 +0100
Received: from moraypc.oucs.ox.ac.uk ([163.1.14.118] helo=moraypc)
	by frontend1.herald.ox.ac.uk with smtp (Exim 2.02 #1)
	id 114g9R-0006tK-00
	for pgsql-interfaces@postgreSQL.org; Thu, 15 Jul 1999 08:41:53 +0100
Message-ID: <002c01bece95$5c4c8440$760e01a3@oucs.ox.ac.uk>
From: "Moray McConnachie" <Moray.McConnachie@computing-services.oxford.ac.uk>
To: <pgsql-interfaces@postgresql.org>
Subject: SELECT... INTO via ODBC
Date: Thu, 15 Jul 1999 08:40:50 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

I've looked around, and I can't find the answer to this:

MS Access, Insight driver 6.40.00.6, in an SQL pass-through query, entering

SELECT regno INTO test FROM tmpsrch;

does nothing, although it works fine from psql. Same for CREATE TABLE AS.

User is the same in both cases, and in any case CREATE TABLE test (regno
int4) works fine as a pass-through query.

Is SELECT INTO impossible via ODBC?

Yours,
Moray