Where should I define the schema name to execute query on specific schema for pg?

[shaishab]

I would like to execute the query on specific schema in postgreSQL. so where can I define the schema name?
tried bellow code but not working

jsonSql.build({
         type: 'select',
          table: 'user',
          schema: 'schemaName',
          fields: fields,
          condition: condition
})

working by this way table: 'schemaName.tableName'

jsonSql.build({
         type: 'select',
          table: 'schemaName.tableName',
          fields: fields,
          condition: condition
})

Is this valid way or have other way ?

[artzhookov]

Your second example is valid, but not looks enow convenient.

What do you think about such format (not working, need to do):

jsonSql.build({
    type: 'select',
    table: {
        schema: 'schemaName',
        name: 'tableName'
    },
    fields: fields,
    condition: condition
});

[shaishab]

I think that's good and schema may be optional that means if we don't define the schema then it should be work for public schema, so both format should work (my opinion)

jsonSql.build({
         type: 'select',
          table: 'tableName',
          fields: fields,
          condition: condition
})

and for

jsonSql.build({
    type: 'select',
    table: {
        schema: 'schemaName',
        name: 'tableName'
    },
    fields: fields,
    condition: condition
});