Is possible to use any schema for sqlpage_files table??

[heejit]

I want to use a dedicated schema for sqlpage app including sqlpage_files table is that possible ?

[heejit]

is to set search path in sqlpage/on_connect.sql ??

[heejit]

schema_name.table_name allowed in sql file ??

[lovasoa]

Yes, SQLpage is built so that you can use any syntax supported by your DB engine directly in your .sql files.

schema_name.table_name works.

[heejit]

what about sqlpage_files table ??

or what is right way to isolated the schema for sqlpage app

[lovasoa]

Yes, the sqlpage_files table should be in the search path of the user sqlpage is connecting with. So it can be in any schema, but you will have to do some configuration on the database side first.

[heejit]

okay so for postgresql I can use set search_path for sqlpage_files and other i can use schema_name.table_name

Thanks.