I suppose I should have named things differently but is there a way to join two tables with a bunch of identical column names and rather than explicitly alias each column just use some sort of wildcard like:

SELECT tablename.* AS  alias.*

OR do I have to name each column like:

columnname as alias

Thanks much.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to