All Questions

Tagged with
Filter by
Sorted by
Tagged with
2
votes
1answer
148 views

PostgreSQL: simple equality query returning no results for indexed columns

I have a very large table (around 140M rows) with five columns: CREATE TABLE IF NOT EXISTS citations ( citing_id text, citing_issn text, cited_id text, cited_issn text, year int ); ...
1
vote
1answer
3k views

Failed import of date using COPY

I'm trying to import a CSV file into a table in Postgres, and it's bombing out on the first date field. The dates are in the format dd/mm/yyyy and there isn't a date in the field in question in the ...
5
votes
3answers
5k views

How do I disable escaping when using COPY FROM in PostgreSQL?

I have a large tab delimited file that I want to read into a table in PostgreSQL 9.5. It contains double-quotes and backslashes that I want to treat as regular characters. I think COPY FROM is the ...
1
vote
1answer
320 views

how to convert my PostgreSQL database table into CSV? [closed]

i need to convert my PostgreSQL table into csv, how to do this? i have visited many sites they suggest the PostgreSQL command to convert the table into CSV but i always get the error message. the ...