Re: Tips/Hacks to create minial DB from the execution of several (simple) SQL requests.

Hi Scott!

The problem is that my test database has several tables with many links between them, so I have no idea which 1000 rows
toget from which table. The only thing I can do is run the program that connects to that database and tell it to run on
asample of the database. 

I can get a log of all the queries that are executed, but I was wondering if there was a more general solution where I
coulduse a "modified/hacked" postgres driver and catch all the rows of all the tables that were accessed during those
queries.

I could then simply insert them into the test database and in theory my program should run the same if I used it
insteadof the real one (assuming its configure to run on the same sample). 

Daniel Shane

>>>QUOTE
I'd create a test schema, set the search path on your test user to just
that schema. And you could create the tables something like so:

CREATE TABLE test.foo AS
   SELECT * FROM public.foo
   LIMIT 1000;

Scott
<<<QUOTE

Daniel Shane wrote:
> Hi all!
>
> I have an interesting problem here that I think could be of interest to everyone. I in the process of writing test
casesfor our applications and there is one problem I am facing. To be able to test correctly, I need to create a small
database(a sample if you want) from a very large one so that I can run some tests on a subset of the data.  
>
> Sometimes you are asked to do this but know nothing about the database in advance (ugh!).
>
> I could create several queries and build it myself by trial and error, but I was wondering if a more general approach
couldbe elaborated. 
>
> ...