SELECT... INTO via ODBC

Поиск
Список
Период
Сортировка
От Moray McConnachie
Тема SELECT... INTO via ODBC
Дата
Msg-id 002c01bece95$5c4c8440$760e01a3@oucs.ox.ac.uk
обсуждение
Список 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 по дате отправления: