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


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: (view raw, whole thread or download thread mbox)
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 ( {

(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


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-2017 The PostgreSQL Global Development Group