Export table to sql file

andrii

Hi,
I need to export a table with all data in an SQL file. The goal is to execute this file locally in Vertica under Docker. Is there any command to do it in a simple way?

mosheg

Does the following answer your question?

cat export_data_from_my_table.sql
\a
\t
\f ','
\o my_table.data
select * from my_table;