[Openroad-users] Removing copy statements from copy.in

[Mark Luijendijk]

Gareth,

2 options:

1. (if your Ingres version supports this): copydb -u<dba> <db> -with_tables
-with_modify -with_index -with_views (etc.)
2. awk '(/create table/||/create view/||/create index/||/create
unique/||/modify/||/grant /),/\\p\\g/' copy.in

Good luck!

Mark


On 6/26/08, gareth.2.edwards at bt.com <gareth.2.edwards at bt.com> wrote:
>
> Hi,
>
> Anyone have a script to remove the copy statements from the copy.in?
>
> I want to just create all the tables/indexes etc, but don't want the
> copy statements. My nawk/awk is rusty.
>
> Cheers,
> Gareth Edwards
>
> BT Global Services
> t: +44 (0)131 300 1907
> e: Gareth.2.Edwards at BT.com
>
> ________________________________________________________________
> OpenROAD-Users mailing list
>
> You can maintain your subscription here:
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
> To unsubscribe click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
> To subscribe click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080626/5caca059/attachment.html