title: is there a command for "AS" in postgres?
body: <p>I'm wondering if there is a command like <code>AS</code> for postgres. Does anyone know if postges has this ability? I've tried to google it but it's a very difficult question to google :P I want to make a select statement and store it as a new table name. I want to say something like:</p>
  
  <p><code>select subj, user as 'new' from table_name;</code></p>