Re: [GENERAL] [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ć wrote: > \d tableName > > > On Wed, Jul 7, 2010 at 11:08 AM, venkat wrote: > >> Dear All, >> >>How to

Re: [GENERAL] Dynamic plpgsql help

Hi, instead of cast(mostype as varchar) try mostype::varchar Thanks Sreelatha On Sun, Apr 4, 2010 at 10:04 PM, Pavel Stehule wrote: > 2010/4/4 Scott Geller : > > Hi > > > > I have the following plpgsql function that works: > > > > DROP TYPE if exists distr CASCADE; > > CREATE TYPE distr AS (b