----- "Sandra Arnold" <ArnoldS@xxxxxxxx> 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 aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
