Re: Bulk_insert in postgresql like Microsoft SQL server

SBob <sbob@xxxxxxxxxxxxxxxxxxxxx> · Wed, 19 Dec 2018 10:45:19 -0700



    Use the \copy command instead of the COPY command
    https://www.postgresql.org/docs/11/app-psql.html
    

    On 12/19/18 10:40 AM, Shreeyansh Dba
      wrote:

    
            Hi
              Devendra,
            

            You can use copy command
                for Bulk Insert in PostgreSQL.

            
          On Wed, Dec 19, 2018 at 10:59 PM Devendra Yadav
            <devendra.857@xxxxxxxxx>
            wrote:

          
            Dear all,
              

              We need to provide copy rights to our
                developer's for bulk inserts. But the
                case is that, for it to happen it needs superuser
                permission which is very expensive thing a DBA can
                grant. 
              Can anybody please suggest if there are
                such tools or utility through which this can be
                achieved and with minimal rights.
              

              Thanks and Regards,
              Devendra Yadav