Search Postgresql Archives

Re: No Data Being Inserted

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux