José Luis Castro a écrit :
> Sorry, Jean-Yves: I have no idea how to do that. Is it necessary? Or -better
> answered- when is necessary to declare a "search_path" variable?
> Thaks for your help.
search_path is a system variable, unique for each role.
command to see what's going on is:
show sear
Sorry, Jean-Yves: I have no idea how to do that. Is it necessary? Or -better
answered- when is necessary to declare a "search_path" variable?
Thaks for your help.
2009/9/25 Jean-Yves F. Barbier <12u...@gmail.com>
> José Luis Castro a écrit :
> > Hi Benoît. Thanks for your kind answer.
> >
> > I m
José Luis Castro a écrit :
> Hi Benoît. Thanks for your kind answer.
>
> I must say, however, the database was created and it's maintained using the
> application "PGAdmin", so I can say with absolute security that the table
> I'm trying to acces has been created, in fact, with a primary key. Also
Hi Benoît. Thanks for your kind answer.
I must say, however, the database was created and it's maintained using the
application "PGAdmin", so I can say with absolute security that the table
I'm trying to acces has been created, in fact, with a primary key. Also I
ran a lot of queries from PGAdmin
> Hi. I've created a schema in a PostreSQL database. The sintax for accessing
> data from the schema is: schema.tableName
> That works fine when trying with .exec method (i.e. "SELECT * FROM
> schema.tableName" or "INSERT INTO schema.tableName VALUES..."), but it
> doesn't work when I try to use th
Hi. I've created a schema in a PostreSQL database. The sintax for accessing
data from the schema is: schema.tableName
That works fine when trying with .exec method (i.e. "SELECT * FROM
schema.tableName" or "INSERT INTO schema.tableName VALUES..."), but it
doesn't work when I try to use the .edit me
