Postgresql export

[Anon]

I am developing B2B portal in PHP and backend postgreSQL.

I have created my database in my local machine.

Now this database should be shifted to remote.

How we have to do???

urgent....

[[deleted]]

"urgent"

isn't it always?

read about pg_dump

[Anon]

you should use pg_dump, just like vincent said.

in the local machine:
pg_dump -f filename database_name

(or pg_dump -u -f filename database_name if you need authentication)
this will save the database in the file you specify.

then you copy the file to the remote host, and you run psql. There you execute the script that you saved in the file you copied, like this:
=#\i filename

that's it.
There're other ways to do it, but I think this is the easiest one.