hello, is there way to export more than 1000 recor...
# off-topicm
MDobs
09/02/2021, 10:12 AMhello, is there way to export more than 1000 records as csv? via the UI
s
Scott P
09/02/2021, 2:51 PMYou can change max rows in Settings > API. Showing more could make the UI very slow, and using something like pgAdmin with would be my recommended way of exporting large datasets
m
MDobs
09/02/2021, 2:52 PMis pgAdmin an external tool to manage databases?
MDobs
09/02/2021, 2:53 PMI've used navicat mostly
s
Scott P
09/02/2021, 2:53 PMScott P
09/02/2021, 2:53 PMI think Navicat would be the MySQL equivalent of pgAdmin (at least in terms of features)
m
MDobs
09/02/2021, 2:53 PMyes through an external tool all is well, but the client was asking for an "easy" way so they can export them themselves, so I was looking for a way through the Supabase UI
MDobs
09/02/2021, 2:54 PMI'll see how the increase to the max rows plays out, thanks for the suggestions!
MDobs
09/02/2021, 2:59 PMwell changing the value to 10000 doesn't update the dropdown on the bottom or allows for more rows 😦
h
hieu
09/02/2021, 11:25 PMhi @User you can use sql editor to export more rows
m
MDobs
09/03/2021, 5:53 AMah great thanks!