django-postgres-copy icon indicating copy to clipboard operation
django-postgres-copy copied to clipboard

Quickly import and export delimited data with Django support for PostgreSQL's COPY command

Results 23 django-postgres-copy issues
Sort by recently updated
recently updated
newest added

Bumps [django](https://github.com/django/django) from 4.0.4 to 4.0.7. Commits e9e9729 [4.0.x] Bumped version for 4.0.7 release. b7d9529 [4.0.x] Fixed CVE-2022-36359 -- Escaped filename in Content-Disposition header. 2eb7ded [4.0.x] Adjusted version 4.0.7 release...

dependencies

Was reading up on how `ON CONFLICT DO NOTHING;` works in the PostgreSQL docs (which is a *great* addition), and saw that `ON CONFLICT DO UPDATE;` is also an option,...

enhancement

Looks like something happened to the docs at [palewi.re/docs/django-postgres-copy](https://django-postgres-copy.readthedocs.io/en/latest/)! I'm getting a 403.

For Django projects having multiple DB connections something like this: ``` DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'HOST': '127.0.0.1', 'NAME': 'default_db', 'USER': 'postgres', 'PASSWORD': 'xxxxxxx', 'OPTIONS': {'options': '-c search_path=sys,public'},...

Since Django 1.11 (current version 3.0), there's a new way of adding indexes to django tables, Meta.indexes (https://docs.djangoproject.com/en/3.0/ref/models/options/#django.db.models.Options.indexes). This package doesn't work with these, it only works with db_index on...

bug

Draft of PR to fix #91 based on timmyGR and igncampa works

while using this lib I really shot our database in the head bc those are default to True we are bulk inserting small pieces (40krows) into a ~400mio table every...

question

Hello, When trying to export a queryset to csv, I was faced with this error: ``` File "/Users/augustinlegalle/.local/share/virtualenvs/medsmart-back-5TZiyDun/lib/python3.7/site-packages/postgres_copy/managers.py", line 220, in to_csv data = compiler.execute_sql(csv_path) File "/Users/augustinlegalle/.local/share/virtualenvs/medsmart-back-5TZiyDun/lib/python3.7/site-packages/postgres_copy/copy_to.py", line 76, in...

enhancement

Maybe putting a little abstract of the code will explain better what is happening: file.csv ``` ColumnName "144,54" "435,12" ``` models.py ``` MyModel(models.Model): my_attr_name = models.DecimalField(max_digits=10, decimal_places=2) objects = CopyManager()...

bug

Hello! I've run into a perms error, which blocks my script from executing the copy in a Django management: `django.db.utils.ProgrammingError: must be superuser to COPY to or from a file`...

bug