pg_dump -h sourcehost -U sourceuser sourcedatabase | psql -h desthost -U
destuser destdatabase
you may have to add a parameter for the password depending on your pg_hba.conf
settings. Both databases need to be network enabled and have a pg_hba.conf
entry for the machine you're running this comm
Hi all,
I am looking for a way to copy whole database to another existing
database.
Any suggestions ?
-
Best regards,
Krzysztof Szadkowski
---(end of broadcast)---
TIP 9: In versions below 8.
Hello All,
I have installed Tsearch-Module for full text indexing .But when I search text
using gist(idxFTI) index on table I also found
all data which have same accent.Example
1.If I try search for MANI word it also search for MANY word.
2.If I try search for ANDY word it also search for ANDI w
Hi,
Good Morning.
We are planning to use postgresql for our Spatial database. Today we have
sucessfully installed the same in our system and created a database and a
table with few columns. Now we need help in the following areas.
How to import data from legacy files to postgres ? (Csv or Txt o
