Postgres Pro
Downloads
Home   >   mailing lists

postgres temporary tables and MS Access - Mailing list pgsql-general

From Zlatko Matić
Subject postgres temporary tables and MS Access
Date
Msg-id 000b01c59048$8ce2dc50$b08a1dc3@zlatkovyfkpgz6
Whole thread Raw
List pgsql-general
Tree view
I tried to work with postgres temporary tables from MS Access, but unsuccessfully...
I was able to create temporary table by pass-through query, also I succeeded in creating linked table through code, but when I try to open it, an error apears and Access says there is no schema...
Also, I couldn't link table using ODBC wizard...
Can someone explain why I can't use temporary tables from MS Access ? Does it mean that every query execution is separate connection, so previously created temporary table no longer works for next queries ?
Has anybody used postgres temporary tables from MS Access ?
 
Thanks in advance,
 
Zlatko

pgsql-general by date:

Previous
From: "NTPT"
Date:
Subject: \dt gives ERROR: did not find '}' at end of input node
Next
From: Michael Fuhr
Date:
Subject: Re: \dt gives ERROR: did not find '}' at end of input node