Re: Populate Table From Two Other Tables

On Tue, 5 Jun 2012, Greg Williamson wrote:

> Try a single equals sign, e.g. WHERE c.site = s.siteid

Greg,

I'm surprised: that worked! I thought the WHERE clause was looking for
equivalency, not an assignment.

There's another problem now that will be more difficult to fix. Postgres
tells me, 'psql:populate-waterchem.sql:6: ERROR: duplicate key value
violates unique constraint "waterchem_pkey"'. But, when I SELECT rows based
on the primary key only a single row is returned.

I think the most parsimonious solution is to use an awk script to add the
stream and basin columns to the chemistry.txt file. That also eliminates
having to export the combined table to a text file.

Thanks,

Rich