SELECT... INTO via ODBC

From: "Moray McConnachie" <Moray(dot)McConnachie(at)computing-services(dot)oxford(dot)ac(dot)uk>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: SELECT... INTO via ODBC
Date: 1999-07-15 07:40:50
Message-ID: 002c01bece95$5c4c8440$760e01a3@oucs.ox.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message apollo 1999-07-15 11:14:29
Previous Message Peter Mount 1999-07-15 06:57:34 RE: [INTERFACES] I'm getting crazy...HELP ME!