which logs do i need to check On Wed, Nov 15, 2017 at 10:04 AM, Juan Pablo Gardella < gardellajuanpa...@gmail.com> wrote:
> Could you check share the logs? Remember PostreSQL does not follow SQL > standard > <https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS> > : > > *"Quoting an identifier also makes it case-sensitive, whereas unquoted > names are always folded to lower case. For example, the > identifiers FOO, foo, and "foo" are considered the same by PostgreSQL, > but "Foo" and "FOO" are different from these three and each other. (The > folding of unquoted names to lower case in PostgreSQL is incompatible with > the SQL standard, which says that unquoted names should be folded to upper > case. Thus, foo should be equivalent to "FOO" not "foo" according to the > standard. If you want to write portable applications you are advised to > always quote a particular name or never quote it.)"* > > Maybe you need to use quoting. > > > On Wed, 15 Nov 2017 at 11:59 Austin Duncan <adun...@pyaanalytics.com> > wrote: > >> All, >> >> I am using putdatabaserecord to insert into a postgres table. The input >> is a flat json record that is being read by a jsonpath reader. The data >> will be inserted but when i look at the table it appears that all of the >> data is null. I also tried using a json tree reader and that didnt work >> either. Any ideas? >> >> >> -- >> Austin Duncan >> *Researcher* >> >> PYA Analytics >> 2220 Sutherland Avenue >> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> >> Knoxville, TN 37919 >> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> >> 423-260-4172 >> >> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> >> <%28865%29%20684-2828> >> > -- Austin Duncan *Researcher* PYA Analytics 2220 Sutherland Avenue <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> Knoxville, TN 37919 <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> 423-260-4172 <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> <%28865%29%20684-2828>