Hey you can Import Files on a Terminal with sudo -u postgres psql < File.txt
Salima Begum <[email protected]> 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 [email protected]. > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKGT9myhW8yn-isEEn1oW9vSUUELpL6GaDbpb-6EWWFKEsnMWw%40mail.gmail.com.
