Subject Database Introspection with Jaybird
Author Fidel Viegas
Hello folks,

I am doing a few database introspections using Jaybird, and I have ran
into some problems. I am able to extract the metadata without any
problems, if the tables are created without delimiters. The minute I
try to introspect a database which has table whose table names and
column names are delimited with double quotes, then the whole thing
fails. That is, I am able to get the table names, but I am unable to
get the columns for that particular table. How do I write some code
that will allow me to get table names and column names with or without
delimiters?

I am using the DatabaseMetadata.getColumns

Another question is what sort of pattern shall I use to return only
the columns for user defined tables?

Thanks in advance,

Fidel.