Re: Limiting records in pg_dump

[Adrian Klaver <aklaver(at)comcast(dot)net>]

----- "Sandra Arnold" <ArnoldS(at)osti(dot)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
aklaver(at)comcast(dot)net