Re: [SQL] trouble with getting the field names

2009-10-26 Thread John
On Monday 26 October 2009 04:41:49 pm John wrote: > Below is a SQL statement that was created to retreive the primary key , and > column names and data types for a table name and a schema. The problem is > that is works very well if I only use the 'public' schema. But it does not > work if I use

[SQL] trouble with getting the field names

2009-10-26 Thread John
Below is a SQL statement that was created to retreive the primary key , and column names and data types for a table name and a schema. The problem is that is works very well if I only use the 'public' schema. But it does not work if I use a 'system' schema I created (owned my me). The offendi