The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Export table to sql file

andriiandrii Vertica Customer

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?



  • moshegmosheg Vertica Employee Administrator

    Does the following answer your question?

    cat export_data_from_my_table.sql
    \f ','
    select * from my_table;

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file