Hey you can Import Files on a Terminal with sudo -u postgres psql < File.txt
Salima Begum <salim...@rohteksolutions.com> schrieb am Mo., 18. Mai 2020, 13:50: > 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/CAKGT9myhW8yn-isEEn1oW9vSUUELpL6GaDbpb-6EWWFKEsnMWw%40mail.gmail.com.
