Retrieving Data from PostgreSQL

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