Help Center> Data Warehouse Service> Best Practices> Tutorial: Tuning Table Design> Appendix: Table Creation Syntax> Usage
Usage
This section provides SQL test statements used in this tutorial. You are advised to copy the SQL statements in each section and save them as an .sql file. For example, create a file named create_table_fir.sql file and paste the SQL statements in section Creating an Initial Table to the file. Executing the file on an SQL client tool is efficient, and the total elapsed time of test cases is easy to calculate. Execute the .sql file using gsql as follows:
1 | gsql -d database_name -h dws_ip -U username -p port_number -W password -f XXX.sql
|
Replace the italic parts in the example with actual values in GaussDB(DWS). For example:
1 | gsql -d postgres -h 10.10.0.1 -U dbadmin -p 8000 -W Bigdata@123 -f create_table_fir.sql
|
Parent topic: Appendix: Table Creation Syntax
Last Article: Appendix: Table Creation Syntax
Next Article: Creating an Initial Table
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.