Hi all,
I have my form submissions in postgreSQL. It all seems fine and I can
access, browse, and manipulate the data using Aggregate. However, when I
connect to postgreSQL via the CLI, I cant get access to the data in a
straight forward manner!
I am forced to enable logging and then use Aggregate to generate the
queries, and from analyzing these queries, I somehow get a picture of what
is going on, though not fully!
How can I get the schema generated for my forms?
Regards
Kihara
Read over http://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure.
If you have questions after, let us know.
···
On Mon, May 7, 2012 at 4:30 AM, Kihara Absolomon wrote:
> Hi all,
>
> I have my form submissions in postgreSQL. It all seems fine and I can
> access, browse, and manipulate the data using Aggregate. However, when I
> connect to postgreSQL via the CLI, I cant get access to the data in a
> straight forward manner!
>
> I am forced to enable logging and then use Aggregate to generate the
> queries, and from analyzing these queries, I somehow get a picture of what
> is going on, though not fully!
>
> How can I get the schema generated for my forms?
>
> Regards
> Kihara
Thanks Yaw Anokwa. It did work. I installed phppgadmin and was able to
browse and see the data.
Thanks
···
On Mon, May 7, 2012 at 4:20 PM, Yaw Anokwa wrote:
Read over
http://code.google.com/p/opendatakit/wiki/AggregateDatabaseStructure.
If you have questions after, let us know.
On Mon, May 7, 2012 at 4:30 AM, Kihara Absolomon soloincc@gmail.com wrote:
Hi all,
I have my form submissions in postgreSQL. It all seems fine and I can
access, browse, and manipulate the data using Aggregate. However, when I
connect to postgreSQL via the CLI, I cant get access to the data in a
straight forward manner!
I am forced to enable logging and then use Aggregate to generate the
queries, and from analyzing these queries, I somehow get a picture of
what
is going on, though not fully!
How can I get the schema generated for my forms?
Regards
Kihara