Re: [HACKERS] Dumb question: How do I determine programmatically if a column is nullable?

2004-01-07 Thread Tom Lane
"Dann Corbit" <[EMAIL PROTECTED]> writes: > In other words, I will be passed a SQL query. I don't want to have to > parse it myself. > Rather, I want to know (for the bound columns) if a column is nullable > or not. > Is the functionality available in [for example] libpq? As of 7.4, see PQftable(

Re: [HACKERS] Dumb question: How do I determine programmatically if a column is nullable?

2004-01-07 Thread Dann Corbit
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 07, 2004 11:17 AM > To: Dann Corbit > Cc: [EMAIL PROTECTED] > Subject: Re: [HACKERS] Dumb question: How do I determine > programmatically if a column is nullable? >

Re: [HACKERS] Dumb question: How do I determine programmatically

2004-01-07 Thread Andreas Pflug
Dann Corbit wrote: What API call can I make to find out if a column is nullable or not? SELECT attnotnull FROM pg_attribute ... see documentation "Internals/System Catalogs" Regards, Andreas ---(end of broadcast)--- TIP 1: subscribe and unsubscri

[HACKERS] Dumb question: How do I determine programmatically if a column is nullable?

2004-01-07 Thread Dann Corbit
Title: Message What API call can I make to find out if a column is nullable or not?