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

Re: SQLTables and szTableRemarks field?

From: Alex Goncharov <alex-goncharov(at)comcast(dot)net>
To: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLTables and szTableRemarks field?
Date: 2009-07-06 00:06:27
Message-ID: E1MNbj1-000MCX-As@daland.home (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
,--- You/Lothar (Mon, 6 Jul 2009 00:37:31 +0200) ----*
| When reading out tables with SQLTables I did not get the remarks field.
| Why is this happen or is it unimplemented?

Per the documentation available online, it is not.

| I bind the columns as follows:
| 	SQLBindCol(hstmt, 1, SQL_C_CHAR, szTableCatalog, TAB_LEN,  
| &cbTableCatalog);
| 	SQLBindCol(hstmt, 2, SQL_C_CHAR, szTableSchema, TAB_LEN,  
| &cbTableSchema);
| 	SQLBindCol(hstmt, 3, SQL_C_CHAR, szTableName, TAB_LEN, &cbTableName);
| 	SQLBindCol(hstmt, 4, SQL_C_CHAR, szTableType, TAB_LEN, &cbTableType);
| 	SQLBindCol(hstmt, 5, SQL_C_CHAR, szTableRemarks, REM_LEN,  
| &cbTableRemarks);

The fifth column of the `information_schema.tables' table is called,
in fact, `self_referencing_column_name', and "applies to a feature not
available in PostgreSQL".

-- Alex -- alex-goncharov(at)comcast(dot)net --

In response to


pgsql-odbc by date

Next:From: Lothar BehrensDate: 2009-07-06 06:42:27
Subject: Re: SQLTables and szTableRemarks field?
Previous:From: Lothar BehrensDate: 2009-07-05 22:37:31
Subject: SQLTables and szTableRemarks field?

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