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

DatabaseMetaData

From: Glenn Holmer <gholmer(at)weycogroup(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: DatabaseMetaData
Date: 2006-05-22 22:34:06
Message-ID: 200605221734.06987.gholmer@weycogroup.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Can someone give me the right incantation to get the names of the 
columns in a table using DatabaseMetaData?  I'm trying

dmd = conn.getMetaData();
rs = dmd.getColumns("pg_attribute", "public", "tsoldto", null);
while (rs.next()) {

(where "tsoldto" is the name of my table) and not getting anything in 
the result set.  What is that last argument supposed to be if I want to 
retrieve all the column names, and are the first two correct?

-- 
____________________________________________________________
Glenn Holmer                          gholmer(at)weycogroup(dot)com
Software Engineer                        phone: 414-908-1809
Weyco Group, Inc.                          fax: 414-908-1601

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-05-22 23:17:14
Subject: Re: DatabaseMetaData
Previous:From: Kris JurkaDate: 2006-05-22 20:14:14
Subject: Re: [BUGS] BUG #2444: XA Connections given by posgres driver has

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