Re: [SQL] How to Get Column Names from the Table

Hi,

 

To get column names only

 

 select column_name from information_schema.columns where table_name='captor_prime_aggregates';

Thanks

Sreelatha

On Wed, Jul 7, 2010 at 2:44 PM, Viktor Bojović <viktor.bojovic@gmail.com> wrote:

\d tableName

On Wed, Jul 7, 2010 at 11:08 AM, venkat <ven.tammineni@gmail.com> wrote:

Dear All,

   How to get Column Names from Table in PostgreSQL.

Thanks and Regards,

Venkat

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me