BUG #5180: How to get only User created tables by using SQLTables() in ODBC

From: "Jitendra Lenka" <jitendra(dot)lenka(at)csqldb(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5180: How to get only User created tables by using SQLTables() in ODBC
Date: 2009-11-12 12:24:42
Message-ID: 200911121224.nACCOgU2030059@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5180
Logged by: Jitendra Lenka
Email address: jitendra(dot)lenka(at)csqldb(dot)com
PostgreSQL version: 8.3.3
Operating system: Fedora10
Description: How to get only User created tables by using SQLTables()
in ODBC
Details:

Hi,

I created a table named "t1" in postgres. Used SQLTables() function in ODBC
to retrieve the table "t1" only. But it retrieves many System and Metadata
tables which bothers me.

Follow below to get all system tables along with user created table "t1".

sql_features
sql_implementation_info
sql_languages
sql_packages
sql_parts
sql_sizing
sql_sizing_profiles
t1

Can I get only user created table ?

If anybody find it good please report it in my mail ID.

Your reply is highly solicited.

Please find the code:
--------------------
retValue=SQLTables(hstmt, NULL, 0, NULL, 0, NULL, 0, (SQLCHAR*) "TABLE",
SQL_NTS);

while (SQL_SUCCEEDED(retValue = SQLFetch(hstmt))) {
SQLUSMALLINT i;
i=3;
if(i<=columns){
SQLINTEGER indicator;
char buf[512];
retValue=SQLGetData(hstmt, i, SQL_C_CHAR,
buf, sizeof(buf), &indicator);
if (SQL_SUCCEEDED(retValue)) {
if (indicator == SQL_NULL_DATA) strcpy(buf, "NULL");
else{
printf("table:%s\n",buf);

}
}
}
}

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2009-11-12 13:22:59 Re: BUG #5171: Composite type with array does not translate in plpythonu
Previous Message Tom Lane 2009-11-11 21:02:20 Re: BUG #5178: make check fails because of locale en_AU.US-ASCII