© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
3 replies
AB$TRACT

[Resolved] Rename a joined table inside a .select() ?

Hi,
I have this code that's working just fine:
  const { data: country } = await supabaseService
    .from("country")
    .select("*, city(*)")
    .eq("slug", params!.country)
    .single();
  const { data: country } = await supabaseService
    .from("country")
    .select("*, city(*)")
    .eq("slug", params!.country)
    .single();

Is there a way to do something like
city(*) AS cities
city(*) AS cities
without renaming my table ?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Is it possible to rename a joined table?
SupabaseSSupabase / help-and-questions
3y ago
How can I rename the variable when I select a table?
SupabaseSSupabase / help-and-questions
4y ago
How to count a joined foreign table?
SupabaseSSupabase / help-and-questions
4y ago
Filter original records, given a joined table
SupabaseSSupabase / help-and-questions
14mo ago