Re: Copying data from a CSV file into a table dynamically

2018-08-14 Thread Ruiqiang Chen
CSV file has no limitation of # of rows, excel max row is 2^20. Am I correct? On Tue, Aug 14, 2018 at 9:46 AM, Ron wrote: > On 08/14/2018 08:38 AM, pavan95 wrote: > >> Hi Adrian, >> >> I tried to use >> *"COPY postgres_log1 FROM '/tmp/abc/xyz/postgresql-`date --date="0 days >> ago" >> +%Y-%m-%d`

searching a value in a variable/field in all tables in a schema

2018-08-30 Thread Ruiqiang Chen
Does anyone have experience of searching a value in a variable/field in all tables in a schema? If you can provide some code not creating stored procedure that would be great. Thanks, Ray

Re: searching a value in a variable/field in all tables in a schema

2018-08-30 Thread Ruiqiang Chen
Thanks! On Thu, Aug 30, 2018 at 4:51 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Aug 30, 2018 at 1:44 PM, Ruiqiang Chen > wrote: > >> Does anyone have experience of searching a value in a variable/field in >> all tables in a schema? >> &g