ansaurus

Question

Answer 1

+2 A:

Seems that it marks the end of a COPY statement

End of data can be represented by a single line containing just backslash-period (\.).
 An end-of-data marker is not necessary when reading from a file, since the end of file 
serves perfectly well; it is needed only when copying data to or from client
applications using pre-3.0 client protocol.

Steven Schlansker 2009-12-30 08:02:40

is there any way to get around it? kinda like set it to ignore it? cause the dump file is almost 12million lines and it's a pain to search all copy statements and replace the end of them to "\." !

omid8bimo 2009-12-30 08:17:19

Don't know of one off the top of my head. However, it should be pretty easy to use some utility like "sed" to change it painlessly...

Steven Schlansker 2009-12-30 08:26:53

You might want to try to figure out how it happened in the first place before you just go edit the file - pg_dump will always generate the proper terminator... (This is one more reason to always use the "custom" dump format, of course)

Magnus Hagander 2009-12-30 10:23:59

well actually the data is not a actual pg_dump format, it's raw data recovered from the disk. i found a way! i used a python piece of code to convert those "." in a new line to "\." :)

omid8bimo 2009-12-30 11:26:09

ansaurus

tags:

views:

answers:

what's "\." in postgresql dump file?

related questions