Re: [SQL] Describe Table

2007-12-17 Thread danap
Thanks guys, That pretty much answers my questions. No there is not an easy way. While the access to a lot of internals to the postgresql database can be advantages it is exactly the kind of thing to break generic code anytime something changes. I think I'll take the harder approach and stick with

Re: [SQL] Describe Table

2007-12-17 Thread Tom Lane
Erik Jones <[EMAIL PROTECTED]> writes: > <[EMAIL PROTECTED]> wrote: >> I've reviewed much of the documentation and the forums, >> but unable to seem to find a easy way to obtain the same >> thing as the 'psql \d table' through sql. > If you start psql with the -E flag, it will display all sql gene

Re: [SQL] Describe Table

2007-12-17 Thread Richard Broersma Jr
--- On Mon, 12/17/07, [EMAIL PROTECTED] > I've reviewed much of the documentation and the forums, > but unable to seem to find a easy way to obtain the same > thing as the 'psql \d table' through sql. I I've never understood the information schema well enough to construct my own sql queries tha

Re: [SQL] Describe Table

2007-12-17 Thread Colin Wetherbee
[EMAIL PROTECTED] wrote: I've reviewed much of the documentation and the forums, but unable to seem to find a easy way to obtain the same thing as the 'psql \d table' through sql. I know I can create through collecting info on table, but seems there must be an easier way. I desire to create a sta

Re: [SQL] Describe Table

2007-12-17 Thread Erik Jones
On Dec 17, 2007, at 10:56 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> wrote: I've reviewed much of the documentation and the forums, but unable to seem to find a easy way to obtain the same thing as the 'psql \d table' through sql. I know I can create through collecting info on table, but se