Postgres Pro
Downloads
Home   >   mailing lists

Re: create batch script to import into postgres tables - Mailing list pgsql-admin

From David G. Johnston
Subject Re: create batch script to import into postgres tables
Date
Msg-id CAKFQuwbhVtbSi4r5e5KJBOFODJs3UVcaqggx97A7xDxpmwB8xA@mail.gmail.com
Whole thread Raw
In response to Re: create batch script to import into postgres tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: create batch script to import into postgres tables
Re: create batch script to import into postgres tables
List pgsql-admin
Tree view
On Fri, Jun 19, 2020 at 6:58 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 6/19/20 6:53 AM, Pepe TD Vo wrote:
> Thank you sir and I am sorry for the typo not having "--" on password. 
> I did spelling out with --password=mypassword

Please go back and read my post again.

To be clear, there is no way to supply a password as a command line argument.  It is fundamentally a bad idea and we don't even make it an option.

You need to decide on one of the actual ways of supplying a password, or choose an alternative authentication method like peer.

David J.

pgsql-admin by date:

Previous
From: jim schmidt
Date:
Subject: Re: Deleting more efficiently from large partitions
Next
From: "David G. Johnston"
Date:
Subject: Re: create batch script to import into postgres tables