To run the Aster Export Tool, you type:
$ ./ncluster_export [arguments] [schemaname.]tablename [ filename ]
where
-
arguments
Command-line flags that control how the exporter runs. The flags are explained in the Argument Flags section, or you can display the help by typing:
$ ncluster_export -? -
schemaname
[Optional] Name of the source table’s schema. If no schema name is provided, Aster Database will search the schemas listed in your current schema search path.
- tablename Name of the source table. See the Case-Sensitive Handling for Table Names section if you want to have Aster Database evaluate table names in a case-sensitive manner. To export from multiple tables, see the section Exporting from Multiple Tables.
- filename Name of the file that will receive the exported data. If you don’t supply a file or directory name argument, Aster Export assumes you want to export to STDOUT. If the filename contains spaces, make sure you enclose it in double quotes.
You can also pipe the results through a standard UNIX command such as gzip. For example:
$ ./ncluster_export -U mjones -w st4g0l33 -h 10.50.52.100 -d mydb mytable | gzip -c > mytable.gz