aboutsummaryrefslogtreecommitdiffstats
path: root/internal/storage/postgresql.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/storage/postgresql.go')
-rw-r--r--internal/storage/postgresql.go20
1 files changed, 13 insertions, 7 deletions
diff --git a/internal/storage/postgresql.go b/internal/storage/postgresql.go
index dee0288..d93d014 100644
--- a/internal/storage/postgresql.go
+++ b/internal/storage/postgresql.go
@@ -29,19 +29,25 @@ func (p PostgresqlAdapter) TableExists(
tableName string,
) (bool, error) {
var exists bool
- // Assumption: Anytime we check if a table exists, it will be
- // for the 'public' schema. If someone wants to have bolt_migrations
- // table outside of the 'public' schema on postgresql, this would be
- // an issue.
+
+ schemaName := "public"
+ parts := strings.Split(tableName, ".")
+ if len(parts) == 2 {
+ schemaName = parts[0]
+ tableName = parts[1]
+ } else {
+ tableName = parts[0]
+ }
+
err := executor.QueryRow(`
SELECT EXISTS (
SELECT FROM pg_catalog.pg_class c
JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
- WHERE n.nspname = 'public'
- AND c.relname = $1
+ WHERE n.nspname = $1
+ AND c.relname = $2
AND c.relkind = 'r' -- Only tables
);
- `, tableName).Scan(&exists)
+ `, schemaName, tableName).Scan(&exists)
if err != nil {
return false, fmt.Errorf(
"unable to check if %s exists: %w",