Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support postgres schema qualifier in queries (and type definitions) #26

Open
uladkasach opened this issue Jul 2, 2020 · 0 comments
Open
Labels
blocker Blocks an in scope use case until completed

Comments

@uladkasach
Copy link
Member

uladkasach commented Jul 2, 2020

we need to be able to support

  SELECT jobsdb.upsert_location(
    :city,
    :state,
    :postal,
    :country
  ) as id;

in addition to

  SELECT upsert_location(
    :city,
    :state,
    :postal,
    :country
  ) as id;

not everyone will want to update their search path - and depending on how they setup their db it could be useful to join cross schemas


consider also:

  • tables
  • views
  • functions

and

  • in queries
  • in ddl
@uladkasach uladkasach added the blocker Blocks an in scope use case until completed label Jul 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
blocker Blocks an in scope use case until completed
Projects
None yet
Development

No branches or pull requests

1 participant