Hello Salima, You could use the COPY command that is documented here.
https://www.postgresql.org/docs/current/static/sql-copy.html But if the data is bulk and that data has to be copied or inserted into the table in a faster manner, your ideal solution is *Pgloader *because of its performance benefits. https://pgloader.readthedocs.io/en/latest/index.html HTH, ~Ram On Mon, May 18, 2020 at 5:50 AM Salima Begum <salim...@rohteksolutions.com> wrote: > Hi , > Mysql query which we used previously now we moved to postgresql, > Here is the below query in mysql , Can anyone help me to write > similar query in postgresql. > > query = "LOAD DATA LOCAL INFILE '41098_category_list.txt' INTO TABLE > pages_rim_ls_categories FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' > " > > Thanks > ~salima > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAMSz6bnNUZ0XK%3DBbnwhNrEcVEe6Lpab0uazxvXtskZcR_MZ2uA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAMSz6bnNUZ0XK%3DBbnwhNrEcVEe6Lpab0uazxvXtskZcR_MZ2uA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2BOi5F3v07erYQF2Wr5B2rqD5Htv3D23crL1e%3D5B1gLLCG3m%2BA%40mail.gmail.com.
