<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18876"></meta>
</head>
<body>
<div align="left">What do you mean by "seeing" the data.</div>
<div align="left"> </div>
<div align="left">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.</div>
<div align="left"> </div>
<div align="left">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".</div>
<div align="left">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.</div>
<div align="left"> </div>
<div align="left">or phppgadmin if you want it in web-interface.</div>
<div align="left"> </div>
<div align="left">/Nicklas</div>
<div align="left"> </div>
<div align="left"> </div>
<div align="left"> </div>
<div align="left"><br />
<br />
2010-03-11 Linnet Kwamboka wrote:<br />
<br />
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.<br />
>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,<br />
> thanks for responding, cheers<br />
>geekmate<br />
></div>
</body>
</html>