Re: Exporting tables/views

Поиск
Список
Период
Сортировка
От Andreas Wenk
Тема Re: Exporting tables/views
Дата
Msg-id 49943FE1.6010206@netzmeister-st-pauli.de
обсуждение исходный текст
Ответ на Exporting tables/views  (salmonix <getforum@gmail.com>)
Список 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-----

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bob McConnell
Дата:
Сообщение: Re: "Existing installation" when there should be none
Следующее
От: JORGE MALDONADO
Дата:
Сообщение: CHANGING THE DATA LOCATION