referencing column names properly - Mailing list pgsql-sql

From Sill-II, Stephen
Subject referencing column names properly
Date
Msg-id 4BAE87828F06EB45B2641B83D370350F45E4@ostex002.ad.ost.dot.gov
Whole thread Raw
Responses Re: referencing column names properly
Re: referencing column names properly
List pgsql-sql
I have a table called logs with several columns whose names have '-' in
them, e.g.   User-Name

I'm having trouble referencing these columns with SELECT statements.

What would the proper way to address these in a statement like this?

SELECT User-Name, max(Date), max(Time) from logs;

I want to return the last login date and time for each username.

Thanks
Stephen Sill II


pgsql-sql by date:

Previous
From: "John Cavacas"
Date:
Subject: Re: query help/sugestions
Next
From: Roberto Mello
Date:
Subject: Re: query help/sugestions