Tom Lane wrote:
>
> Robert Hiltibidal <rob@y2k.state.il.us> writes:
> > I have unique tables in crossover i want to migrate over to crbak. Can this
> > be done thru SQL?
>
> No; in Postgres, different databases are different universes ... and
> there are no wormholes in SQL ;-).
>
> Use pg_dump with -t to dump out the table(s) you want from the one
> database, and then load the resulting script into the other.
You can do it in one shot like this:
pg_dump -t unique_table crossover | psql crbak
-------------------
Hannu
