Re: [JDBC] Patch for Statement.getGeneratedKeys()

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Wed Jan 16 2008 - 10:01:58 EST

Ken Johanson <pg-user@kensystem.com> writes:
> Here is what I have so far (not sure of my conditionals yet or if I need
> any joins for them):

> select attname from pg_attribute
> where attrelid = 'postgres.public.test'::regclass
> and attstattarget=-1
> and attisdropped='f'
> order by attnum asc

I'd do "where attrelid = ... and attnum > 0 and not attisdropped". Not sure what you think the attstattarget condition would accompllish, but it doesn't seem like anything that client-side code ought to be touching.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------

TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq Received on Wed Jan 16 10:04:35 2008