accessing schemas in postgresql

Question

I'm new to postgresql and i'd like to access a table named Paths located in the schemas as shown in this image :

https://i.sstatic.net/M6aTn.jpg

in pgadmin this request works :

select * from "Schemas"."Paths"

but i can't make it work in php.

i've tried this so far :

pg_prepare($connection, "my_query", "Select * from \"Schemas\".\"Paths\"");
pg_execute($connection,"my_query");

but it didn't work...

Edit: I don't have an error i just get NULL when i try :

var_dump(pg_fetch_array(pg_execute($connection,"my_query")));

d1ll1nger · Accepted Answer · 2014-06-05 14:44:34Z

1

pg_prepare($connection, "my_query", 'Select * from "Schemas"."Paths"');
pg_execute($connection,"my_query");

edited Jun 5, 2014 at 14:44

answered Jun 5, 2014 at 14:36

d1ll1nger

1,70113 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Cratein Over a year ago

Well i had tried without the quotes and it didn't work neither in php nor in pgadmin. Note that i don't have an error but the result is null when i try var_dump(pg_fetch_array(pg_execute($connection,"my_query")));

d1ll1nger Over a year ago

Ahh ok, i see. It's probably because of the reserve words. Try this (see edit).

Cratein Over a year ago

hum still not working but i can't even retrieve anything from a metatable. I'm switching to java servlet! thanks anyway!

Collectives™ on Stack Overflow

accessing schemas in postgresql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related