Hi,
We are trying to insert the data from a text file '*some_category_list.txt*''
into a table in Postgres database using the highlighted query in our
functions.py
file = open(str(a)+'_category_list.txt', 'r')
> file_content = file.read()
> print(file_content)
> file.close()
> from django.db import connection
> cursor = connection.cursor()
> *query = "COPY pages_rim_ls_categories FROM '{0}_category_list.txt' WITH
> DELIMITER AS '|'".format(str(a)) *
> cursor.execute(query)
>
>
and we are getting this error
django.db.utils.OperationalError: could not open file
> "some_category_list.txt" for reading: No such file or directory
>
> HINT: COPY FROM instructs the PostgreSQL server process to read a file.
> You may want a client-side facility such as psql's \copy.
>
Note: We used below query in the past using MySQL and it worked fine with
that.
query = "LOAD DATA LOCAL INFILE '*some_category_list.txt'* INTO TABLE
> pages_rim_ls_categories FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' "
>
We are wondering what we are missing. Could someone help here to verify
this?
Best regards
~Ram
--
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%2BOi5F2P8Oy-gOUWC54imqcNvdmHw3LuC%3DuKkR5Xzq_w3HXjjA%40mail.gmail.com.
