sql query
Jude DaShiell
jdashiel at shellworld.net
Tue May 6 11:59:20 UTC 2014
Hi Tim,
I'm pretty sure this will work correctly. Thanks much; I intend to use
sql for more tables and data than this one so this help you provided
will get me well set up for the future.
On Mon, 5 May 2014, Tim Chase wrote:
> I'm not quite sure I fully understand the trouble you're having, but
> I'm game to take a stab at it, even if it's a SQL/PostgreSQL
> question on a Linux list. (grins) If I understand correctly, you want
> to be able to
>
> 1) give meaningful names to columns that would otherwise have their
> names defaulted (such as from aggregate functions), and
>
> 2) make it easier to read by including the headers with each value
>
> You can rename columns using the "AS" keyword if that would help:
>
> select
> grouping_field,
> round(avg(sug),1) as Rounded_Average,
> count(*) as Count_of_Records
> from some_table
> group by
>
> That can be combined with the "\x" command to get the headers on each
> row with a record-separator. This should produce output something
> like
>
> -[ RECORD 1 ]-
> grouping_field | alpha
> Rounded_Average | 3.1
> Count_of_Records | 3
> -[ RECORD 2 ]-
> grouping_field | delta
> Rounded_Average | 6.2
> Count_of_Records | 4
> -[ RECORD 3 ]-
> grouping_field | gamma
> Rounded_Average | 2.5
> Count_of_Records | 1
>
>
> If that doesn't get you what you want, if you can try and describe
> more clearly what you want, I can take another stab. Hope this helps,
>
> -Tim
>
>
>
>
> On May 5, 2014, Jude DaShiell wrote:
> > I wrote a query in sql using psql for an interactive environment in
> > console mode. I can get a couple different kinds of output neither
> > of which would be useful for production level work. The column
> > names from which data was taken in a table would be informative if
> > those were to show up to the left of the values but that's a
> > different kind of output and what is also happening when I use an
> > aggregate function say round(avg(sug),1) is that the function shows
> > with its result on output. That particular formula was used to
> > calculate average blood sugar for a set of data. I can use \t and
> > turn off all tuples and then all I read are the rounded averages
> > again with no explanatory text. I understand all of this since I
> > wrote the query but someone else who doesn't know what Linux is
> > never mind what postgresql is needing to look at this data without
> > assistance is going to have a hard road to travel. I was reading up
> > on comment (7) but unless those \D directives can operate like \t
> > and show column names and comments written for aggregate functions
> > that won't be a workable solution.
> >
> >
> >
> > jude <jdashiel at shellworld.net>
> >
> > _______________________________________________
> > Blinux-list mailing list
> > Blinux-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/blinux-list
>
> _______________________________________________
> Blinux-list mailing list
> Blinux-list at redhat.com
> https://www.redhat.com/mailman/listinfo/blinux-list
>
>
jude <jdashiel at shellworld.net>
More information about the Blinux-list
mailing list