title: How to use Excel Power Query to access a postgresql database
body: <p>We have a postgresql 9.0 database which we want to connect to via Excel 2010 running the Power Query plugin. I've setup the machine running excel to be able to use Npgsql to do the connection according to these instructions <a href="http://office.microsoft.com/en-us/excel-help/connect-to-a-postgresql-database-HA104028095.aspx?CTT=5&amp;origin=HA104003952" rel="nofollow">http://office.microsoft.com/en-us/excel-help/connect-to-a-postgresql-database-HA104028095.aspx?CTT=5&amp;origin=HA104003952</a>. The connection fails in Excel with this error message: </p>
  
  <blockquote>
    <p>DataSource.Error: PostgreSQL: ERROR: 42883: function
    concat(information_schema.character_data, unknown) does not exist
    Details: Message=ERROR: 42883:..., ErrorCode=-2147467259</p>
  </blockquote>
  
  <p>Has anyone successfully connected to a postgresql database from Excel using the Power Query plugin? There's a menu item on the power query ribbon in excel specifically for postgresql so I figured it would work. The concat function isn't in our postgresql version of 9.0 so do I have to upgrade our postgresql database to do this?</p>