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);
}
}
}
}
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 |