| From: | Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de> |
|---|---|
| To: | salmonix <getforum(at)gmail(dot)com> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Exporting tables/views |
| Date: | 2009-02-12 15:27:29 |
| Message-ID: | 49943FE1.6010206@netzmeister-st-pauli.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
salmonix schrieb:
> Hi there,
> I would like to export PostgreSQL tables - or views - into separate
> db for SQLite - these are going to be passed around for offline work.
> I have thought of using triggers on the tables/columns when changed to
> immediately create an export copy, so clients can download these updated
> db's for work.
Hi,
another idea is to do that server sided with pg_dump by using paramater -t ("Dump only
tables (or views or sequences) matching table") and a cronjob ....
Checkout man pg_dump, man pg_restore and the doku ...
Cheers
Andy
> I have found thin doc on it - probably my bad -, so asking for help.
> Thanks a lot,
> Laslo Forro
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJlD/hVa7znmSP9AwRAqDgAJ4hKygGRd+j1wAN2dy3yJDXSNhU8wCfX89P
I9dqdy7XyJJn4WLe1tTGNw8=
=KeRr
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2009-02-16 18:27:10 | CHANGING THE DATA LOCATION |
| Previous Message | Bob McConnell | 2009-02-12 11:41:35 | Re: "Existing installation" when there should be none |