----- "Sandra Arnold" <arno...@osti.gov> wrote:
> Thanks for that suggestion. Since I have a schema on the database, I > could create the view on my schema or even a table with the same name > with just the records that I want to copy to the other database. I > had thought about the table but not necessary the view. > > We are just in the process of looking at PostgreSQL as a solution to > replace Oracle. Those high Maintenance and Support cost have made it > necessary to find a replacement for Oracle. > > How about the COPY command: http://www.postgresql.org/docs/8.4/interactive/sql-copy.html Be sure and read to the bottom where it explains that this is a server command and needs to be run on the server and as the Postgres user. An alternative is \copy run from psql, documentation here: http://www.postgresql.org/docs/8.4/interactive/app-psql.html It runs locally and as the local user. Adrian Klaver akla...@comcast.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
