Re: [EXT]Re: running \copy through perl dbi ?

On 12/10/23 10:34, Johnson, Bruce E - (bjohnson) wrote: On Dec 10, 2023, at 10:41 AM, Vincent Veyron > wrote: External Email On Fri, 8 Dec 2023 10:45:28 -0500 Duh! I just realized that what I proposed with system() is a command line approach. As David

Re: [EXT]Re: running \copy through perl dbi ?

On Dec 10, 2023, at 10:41 AM, Vincent Veyron mailto:vv.li...@wanadoo.fr>> wrote: External Email On Fri, 8 Dec 2023 10:45:28 -0500 David Gauthier mailto:dfgpostg...@gmail.com>> wrote: I'm trying to run a PG client side "\copy" command from a perl script. I tried using $dbh->do("\\copy ...")

Re: running \copy through perl dbi ?

On Fri, 8 Dec 2023 10:45:28 -0500 David Gauthier wrote: > > I'm trying to run a PG client side "\copy" command from a perl script. I > tried using $dbh->do("\\copy ...") but it barffed when it saw the '\'... > ERROR: syntax error at or near "\" > > I can do this with a command line approach,

Re: Question on overall design

* PG has pgbench; *maybe* you can hack it to work on Oracle. * If you want to know how well an RDBMS will work on your workload, then you must provide it with a simulated workload. Right? * AWS RDS Postgresql has a dashboard that *might* be similar to AWR. Or it might not... * We departitioned

Re: Question on overall design

Thank you so much Ron. I have some more doubts related to this. We were thinking , if there is any utility in PG with which we can create/generate large sample data volume which we can use to run it on our on premise Oracle exadata box and use the same on the aurora postgresql in cloud to see