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 по дате отправления:

Предыдущее
От: Peter Mount
Дата:
Сообщение: RE: [INTERFACES] I'm getting crazy...HELP ME!
Следующее
От: "Robson Martins"
Дата:
Сообщение: Re: [INTERFACES] I'm getting crazy...HELP ME!