Query to information_schema.columns selects columns from all schemas

[rwest202]

fortune-postgres/lib/index.js

Lines 141 to 142 in 7d158ec

	const getColumns = 'select * from information_schema.columns ' +
	`where table_name = '${mappedType}'`

Let's say I have a schema named schema-v1 and another named schema-v2 that both have a table called users. If schema-v1 has a column in users like users.email then the below if statement will wrongly think that the column exists in schema-v2. This is because information_schema.columns returns a list of columns in all schemas.

fortune-postgres/lib/index.js

Line 188 in 7d158ec

if (!tableColumns[type].some(row => row.column_name === field) &&

Solution should be to specify the exact schema to search in.

[gr0uch]

Hmm I see, but does this cause any errors?

[rwest202]

It doesn't add the columns to the new schema, since it thinks they already exist. I was able to resolve my issue by removing the schema-v1. But it wasn't immediately obvious what was causing the issue.

[rwest202]

Looks like there is a table_schema key that you can check against, so something like

if (!tableColumns[type].some(row => row.column_name === field && row.table_schema === currentSchema)