PostgreSQL SELECT question

[Madison Kelly]

Ian Petersen wrote:
> 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
> 

I read up on VIEWs 
(http://www.postgresql.org/docs/8.1/interactive/sql-createview.html) but 
it doesn't show any examples. I can't figure out mainly how to split the 
email address provided by postfix into two sections of the query...

Madi
--
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