PostgreSQL SELECT question

[Ian Petersen]

I think you want a view.  Something like this:

CREATE VIEW virtual_table AS <your query here>;

Also, have a look at \h CREATE VIEW in psql.

Ian

-- 
Tired of pop-ups, security holes, and spyware?
Try Firefox: http://www.getfirefox.com
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists