Re: [GENERAL] Limiting records in pg_dump

----- "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