101 reputation
bio website
location České Budějovice
age 43
visits member for 2 years, 2 months
seen Jan 29 at 8:41

Mar
1
comment Error importing back a postgres db after dumping
Simple try to search psql.exe, you will have it in the directory, where is Postgres installed in, in the 'bin' subdirectory. Then try to use it for importing dump, as I or tscho wrote. I've tried to download installation package for Win 64bit and there was psql.exe binary.
Feb
23
comment Error importing back a postgres db after dumping
@yankitwizzy Are you sure? Can you explore Postgresql installation directory, if there is not a psql binary? I don't know Postgres under Windows, but on Linux, there is psql utility standard part of postgresql client instalation... My opinion is, that there is someone changing a tabs to spaces, maybe internet browser? Otherwise I have no idea, where is problem, I'm sorry.
Feb
23
comment Error importing back a postgres db after dumping
@yankitwizzy Hmmm... Can you try to import this file via psql -h machine.with.postgresql -U username -f name.of.dumped.file name_of_database command? Will it produce the same error?
Feb
23
comment Error importing back a postgres db after dumping
@yankitwizzy According to this question on stackoveflow it can did it. Can you check, if there are a tabs between values?
Feb
23
comment Error importing back a postgres db after dumping
@yankitwizzy I'm sorry, but I'm trying to help you :-). It is possible, that editor, in which you searched a text, changed for example tabs to spaces?
Feb
23
comment Error importing back a postgres db after dumping
@yankitwizzy Because it is line 48882 - have you ended previous statement correctly? (By semicolon, for example)? Or is there a good number of parameters on this line?