Re: Dumb question: How do I determine programmatically if a column is nullable?
| От | Dann Corbit |
|---|---|
| Тема | Re: Dumb question: How do I determine programmatically if a column is nullable? |
| Дата | |
| Msg-id | D90A5A6C612A39408103E6ECDD77B8294CE557@voyager.corporate.connx.com обсуждение исходный текст |
| Ответ на | Dumb question: How do I determine programmatically if a column is nullable? ("Dann Corbit" <DCorbit@connx.com>) |
| Ответы |
Re: Dumb question: How do I determine programmatically if a column is nullable?
|
| Список | pgsql-hackers |
> -----Original Message----- > From: Andreas Pflug [mailto:pgadmin@pse-consulting.de] > Sent: Wednesday, January 07, 2004 11:17 AM > To: Dann Corbit > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Dumb question: How do I determine > programmatically if a column is nullable? > > > 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" Is there a way do do it when I have some arbitrary query that returns a result set? 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?
В списке pgsql-hackers по дате отправления: