Re: how to output column names

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Michael Dengler wrote:
> Hi,
> 
> Is there a query I can perform (perhaps on a system table) to return all
> of the column names  (ONLY the column names) for a given DB? (I seem to
> remember doing this before but cant remember how)
> 
> Thanks
> 
> Mike
> 

The 'columns' view in information_schema should do the trick for you.

-Jon

-- 
Senior Systems Developer
Media Matters for America
http://mediamatters.org/


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux