[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?

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

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? Dann Corbit wrote: What API

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() and