How can I export a table to csv?

What would be the best option to export a postgres table to csv?

oh sorry, did not specify. Yes

I found this: https://blog.railway.app/p/postgre-backup

is it still valid solution?

Thank you

pg_dump seems the way to go

The name "pg_dump" threw me off

btw... what format does pg_dump uses?