Re: Limiting records in pg_dump
От | Adrian Klaver |
---|---|
Тема | Re: Limiting records in pg_dump |
Дата | |
Msg-id | 1382063099.6939611249071503018.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net обсуждение исходный текст |
Ответ на | Limiting records in pg_dump ("Arnold, Sandra" <ArnoldS@osti.gov>) |
Список | pgsql-general |
----- "Sandra Arnold" <ArnoldS@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 thePostgres 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@comcast.net
В списке pgsql-general по дате отправления: