On Thu, Oct 2, 2014 at 2:23 PM, Louis <[email protected]> wrote:
>
>
> On Mon, 29 Sep 2014, Chris Travers wrote:
>
>
>> 2. Entities tables (customers/vendors) can be dumped and reloaded as is:
>> entity, company, person, entity_credit_account, location, eca_to_contact,
>> eca_to_location, users
>>
>
> A goal of an export/import is to clean up such items as the control_code
> and the various id columns, and to limit the import to current relevant
> records.
>
> Are you thinking that one does a pg_dump of the tables and then edit them
> for consistancy prior to loading them into the new db?
>
You could do that. Another trick is to do COPY table TO file WITH CSV;
Then that makes it easy to edit the data in a spreadsheet of your choice.
Then after db creation you can:
COPY table FROM file WITH csv;
And if the schema has changed, you can specify a column list.
>
>
>
>> Best Wishes,
>> Chris Travers
>>
>>
>>
>
> Louis
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
