+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: New to CI : Am I missing something (postgresql) (/showthread.php?tid=2580)
New to CI : Am I missing something (postgresql) - El Forum - 08-13-2007
[eluser]Unknown[/eluser]
OK so I setup my db stuff, setup the scaffolding trigger etc etc. Basically my database uses schemas to break apart data. In this instance i am breaking them up by app name in 1 database.
site_management
... application1
---- table1
---- table2
...application2
----table1
----table2
So I setup a scaffold call in a sample controller and I get SELECT COUNT(*) AS numrows FROM "application1.table1"
When I run the query without the quotes in my postgresql it works. but when it has the " in the query it is thrown off. Am I missing an option here somewhere?
- Andy