On Fri, 18 Jul 2003, Yudie wrote:
> Hi,
> Anyone know how the procedure or commands to copy table to another database.
> or querying from another database if possible?
If you want to copy a table from one db to another, you can use this:
pg_dump dbname -t tablename |psql dbname -e
If you want cross database queries, look in the /contrib/dblink dir in the
tarball of postgresql
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
