what do t after postgres sql?

Question

plese anyone tell me what the meaning of "t" after this postgres Sql query.

const query = select jsonb_agg(single_day) as availability from (select jsonb_build_object('day', day, 'hours_format', min(hours_format),'time_array', jsonb_agg(jsonb_build_object('start_time', start_time, 'end_time', end_time) order by start_time ASC)) as single_day from provider_availability where user_id = ${user_id} group by day) t,

It's a table alias. I.e. a name for the subquery.

jarlh
– jarlh

2022-04-05 10:19:11 +00:00
Commented Apr 5, 2022 at 10:19 — jarlh
– jarlh, Commented Apr 5, 2022 at 10:19
It's a table alias

user330315
– user330315

2022-04-05 10:21:29 +00:00
Commented Apr 5, 2022 at 10:21 — user330315
– user330315, Commented Apr 5, 2022 at 10:21

Pebbles · Accepted Answer · 2022-04-05 11:09:02Z

2

t is a table alias for the subquery in the FROM clause, which allows you to then reference that table alias in other clauses (e.g WHERE t.start_time = [time]). Just using the alias name on its own immediately after the closing bracket of the subquery is shorthand for writing AS t.

answered Apr 5, 2022 at 11:09

Pebbles

488 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

what do t after postgres sql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related