[ckan-dev] Erase Datastore

Mon May 19 05:00:20 UTC 2014

All the data is in a separate database, so you only need to clear this one.

I like to use this query to generate the sql to delete all datasets:

`select 'drop table "' || tablename || '" cascade;' from pg_tables where schemaname = 'public';`

On May 18, 2014, at 21:27, Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz> wrote:

> Hi, how do you erase all the datasets and resources in the datastore (completely empty it), but leave in place the Organisations, and Members who have registered.
> 
> Previously we've had a clean out of our test site but took out organisations and members at the same time.
> 
> Thanks
> 
> ________________________________
> 
> Please consider the environment before printing this email
> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
> The views expressed in this email may not be those of Landcare Research New Zealand Limited. http://www.landcareresearch.co.nz
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 455 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140518/4bcf19e3/attachment-0003.sig>