Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group