Q: How to exclude system columns from the result of SQLColumns()?

Hello folks,

This is probably a FAQ, but I have failed to find the answer in the mailing
list archive.

In the DSN Datasource options (ANSI driver 08.02.0100), the ShowSystemTables
and OID boxes are unchecked. But call to SQLColumns always returns tableoid,
oid xmin and the others. Is there any setting to turn this off?
--
Sincerely,
Dmitriy Ivanov
Common Lisp ODBC interface - lisp.ystok.ru/ysql.html




---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Q: How to exclude system columns from the result of SQLColumns()?

Dmitriy Ivanov wrote:
> Hello folks,
>
> This is probably a FAQ, but I have failed to find the answer in the mailing
> list archive.
>
> In the DSN Datasource options (ANSI driver 08.02.0100), the ShowSystemTables
> and OID boxes are unchecked. But call to SQLColumns always returns tableoid,
> oid xmin and the others. Is there any setting to turn this off?

Could you send me the Mylog output ?

regards,
Hiroshi Inoue


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org