Results of 1 - 10 of about 69 for Usage (0.001 sec.)
- DESCRIBE Statement 11976
- The DESCRIBE statement shows the schema of a table, view or query. Usage DESCRIBE tbl; To describe a query, prepend DESCRIBE to a query. DESCRIBE SELECT * FROM tbl; Alias The SHOW statement can also describe tables and queries, but this usage
... - https://man.mtool.work/duckdb/2.0/sql/statements/describe.html
- Quack Extension 11580
- The quack extension adds support for the Quack remote protocol. Usage New DuckDB 2.0.0 shipped a polished version of the Quack protocol that is faster and more stable. Expect further improvements in upcoming patch releases. Quack is transpa
...uld like to install Quack explicitly, run: INSTALL quack; If you would like to load Quack explicitly, run: LOAD quack; For usage details, see the Quack remote protocol page .... - https://man.mtool.work/duckdb/2.0/core_extensions/quack.html
- SQLite Import 10237
- To run a query directly on a SQLite file, the sqlite extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL sqlite; To load the sqlite extension
...for usage, use the LOAD SQL command: LOAD sqlite; Usage After the SQLite extension is installed, tables can be queried from SQLite u... - https://man.mtool.work/duckdb/2.0/guides/database_integration/sqlite.html
- MySQL Import 10053
- To run a query directly on a running MySQL database, the mysql extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL mysql; To load the mysql ex
...tension for usage, use the LOAD SQL command: LOAD mysql; Usage After the mysql extension is installed, you can attach to a MySQL database us... - https://man.mtool.work/duckdb/2.0/guides/database_integration/mysql.html
- PostgreSQL Import 9855
- To run a query directly on a running PostgreSQL database, the postgres extension is required. Installation and Loading The extension can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL postgres; To load t
...he postgres extension for usage, use the LOAD SQL command: LOAD postgres; Usage After the postgres extension is installed, you can attach a PostgreSQL dat... - https://man.mtool.work/duckdb/2.0/guides/database_integration/postgres.html
- Command Line Client 9474
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...the command duckdb to run the executable. If in a PowerShell or POSIX shell environment, use the command ./duckdb instead. Usage The typical usage of the duckdb command is the following: duckdb ⟨OPTIONS⟩ ⟨FILENAME⟩ Options The ⟨OPTIONS⟩ part encodes a...er, the information on the connection and a prompt starting with a D . duckdb DuckDB v2.0.0 (Cyanoptera) Enter ".help" for usage hints. «memory» D To open or create a persistent database , simply include a path as a command line argument: duckdb my_da...d: duckdb -init prompt.sql This outputs: -- Loading resources from prompt.sql DuckDB v2.0.0 (Cyanoptera) Enter ".help" for usage hints. «memory» D ⚫◗ Non-Interactive Usage To read/process a file and exit immediately, redirect the file contents in to d... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Information Schema 9078
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...2.0. VARCHAR NULL New The is_generated and generation_expression columns were introduced in DuckDB 2.0. constraint_column_usage : Constraint Column Usage This view describes all columns in the current database that are used by some constraint. For a...ontains the constraint VARCHAR 'main' constraint_name Name of the constraint VARCHAR 'exam_id_students_id_fkey' key_column_usage : Key Column Usage Column Description Type Example constraint_catalog Name of the database that contains the constraint (a... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Dot Commands 8894
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...follow , --readonly , --sql .output ⟨FILE⟩ Send output to FILE or stdout if FILE is omitted .pager ⟨OPTIONS⟩ Control pager usage for output. See the paging section for details .print ⟨STRING...⟩ Print literal STRING .progress_bar ⟨COMPONENT⟩ Set the p...he .progress_bar command supports --add and --clear parameters for adding and removing components. For details on specific usage, see the examples below. Configuring the Progress Bar Display To check if the progress bar is enabled: SELECT * FROM duckd...itional components on the progress bar. To set that progress bar component to a blue text that displays the file cache RAM usage on the progress bar: .progress_bar --add "{align:right}{min_size:20}{color:blue}External Cache Usage: {sql:select format_b... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- ODBC API on Linux 8696
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...for all users, because of that it requires root privileges. batch sudo ./unixodbc_setup.sh -s The option --help shows the usage of unixodbc_setup.sh prints the help. batch ./unixodbc_setup.sh --help ```text Usage: ./unixodbc_setup.sh [options] Exampl... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- SUMMARIZE Statement 8696
- The SUMMARIZE statement returns summary statistics for a table, view or a query. Usage SUMMARIZE tbl; To summarize a query, prepend SUMMARIZE to a query. SUMMARIZE SELECT * FROM tbl; See Also For more examples, see the guide on SUMMARIZE .
... - https://man.mtool.work/duckdb/2.0/sql/statements/summarize.html
DuckDB 2.0 Documentation / man.mtool.work