Can original file get corrupted during copying?
Is there any chance that the original files on my computer could get corrupted because copying process failed for any reason? Any chance? … Read more
copy
Copying files: does Windows write to disk if files are identical?
Robocopy. Windows cannot differentiate between identical and modified files if you copy using Windows Explorer. Windows can differentiate between identical and modified files … Read more
Parsing COPY’s binary format to access a tsrange
How is tsrange stored in binary? For example create table CREATE TABLE public.test (t tsrange); INSERT INTO test VALUES (‘[2010-01-01 14:30, 2010-01-01 15:30)’); … Read more
Escaping delimiter in postgresql
I am trying to import data into postgres. Data fields are comma separated, strings may contain commas, in which case those are escaped: … Read more
Change permissions of postgres copy to exported file
I have asked this question on SO but perhaps that was the wrong location. Apologies for double posting but the question may have … Read more
Is Vertica’s COPY atomic?
Seems like a simple thing, but I can’t seem to find it in the docs for COPY. Is Vertica’s COPY atomic? If a … Read more
postgres \copy file to RDS timeout
Postgres version 9.3, hosted on Amazon RDS. I have a messages table with 10G of data. I connected the database using psql on … Read more
Copy-only as the routine backup
We are in planning to upgrade from SQL Server 2008 R2 to SQL Server 2014, with the intention of using Availability Groups. One … Read more
How do I use the `COPY` command with JDBC
So I’ve been working with postgre databases and I noticed that it throws an error sometimes when I try to read a csv … Read more
CREATE DATABASE … WITH TEMPLATE seems to lose relations in PostgreSQL
I’m trying to Create a copy of a database in postgresql per the SO answer from 2009, but running into problems. In Postgres … Read more
