On 10/11/23 04:46, Anthony Apollis wrote:
> I have a table that i populate using joins.
> One of the tables don't insert its data. Tables are:
> My Test to see if the data has been inserted:
> image.png
> I get blanks or no output for above test.
>
> My Source Tables have data:
> image.png
> Can't seem to figure out where the issue is.
1) Verify that your client is not lying to you, use psql to see if there
is data in the table.
2) Look at the Postgres log to see what is happening. You would want
log_statement in postgresql.conf to be at least 'mod'.
--
Adrian Klaver
adrian.klaver@aklaver.com