[postgis-users] php/postgresql trouble

[Nicklas Avén]

What do you mean by "seeing" the data. Fysically it is stored where you have your tablespace. The default is the data-folder in your postgresql-installation. But there is nothing to see. You see your data through some application with sql or you can in pgAdmin choose to get the table presented by rightclicking the table and choose "view data".I use to handle the data with the sql window in pgAdmin but you can also use psql in linux terminal or dos-propt in windows. or phppgadmin if you want it in web-interface. /Nicklas   

2010-03-11 Linnet Kwamboka wrote:

Hey i managed to solve the problem, the simple solution was to just use lowercase in both cases both in db and in PHP code.
>my other question is now that i have successfully inserted into the db, where is that data stored i cant seem to see it(am very new to postgresql), i know the daa is there since when i run a retrieve SELECT query, i can see the data in a form, so where in the db is it,
> thanks for responding, cheers
>geekmate
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100311/f4f25cd5/attachment.html>