Results of 1 - 10 of about 137 for column (0.012 sec.)
- Relational API – DuckDB 10776
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...extIOBase] Path to the CSV file or buffer to read from. header : Optional[bool], Optional[int] Row number(s) to use as the column names, or None if no header. compression : Optional[str] Compression type (e.g., 'gzip', 'bz2'). sep : Optional[str] Delim...limiter : Optional[str] Alternative delimiter to use. dtype : Optional[Dict[str, str]], Optional[List[str]] Data types for columns. na_values : Optional[str], Optional[List[str]] Additional strings to recognize as NA/NaN. skiprows : Optional[int] Numbe...estamps. sample_size : Optional[int] Number of rows to sample for schema inference. all_varchar : Optional[bool] Treat all columns as VARCHAR. normalize_names : Optional[bool] Normalize column names to lowercase. null_padding : Optional[bool] Enable nu... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- ALTER TABLE Statement – DuckDB 10656
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...hanges the schema of an existing table in the catalog. Examples CREATE TABLE integers ( i INTEGER , j INTEGER ); Add a new column with name k to the table integers , it will be filled with the default value NULL : ALTER TABLE integers ADD COLUMN k INTE...GER ; Add a new column with name l to the table integers, it will be filled with the default value 10: ALTER TABLE integers ADD COLUMN l INTEGER...DEFAULT 10 ; Drop the column k from the table integers: ALTER TABLE integers DROP k ; Change the type of the column i to the type VARCHAR using a stand... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_table.html
- Query – DuckDB 9745
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...sed to clean up the result. Elements can be extracted from the duckdb_result object using a variety of methods. The duckdb_column_count can be used to extract the number of columns. duckdb_column_name and duckdb_column_type can be used to extract the n...ames and types of individual columns. Example duckdb_state state ; duckdb_result result ; // create a table state = duckdb_query ( con , "CREATE TABLE integer...uckdb_fetch_chunk function. Note that the function is NOT generic: we do need to know exactly what the types of the result columns are. duckdb_database db ; duckdb_connection con ; duckdb_open ( nullptr , & db ); duckdb_connect ( db , & con ); duckdb_r... - https://man.mtool.work/duckdb/1.3/clients/c/query.html
- Information Schema – DuckDB 9589
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...iews 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's information schema . Tables character_sets : Character Sets Col...aining the default collation. VARCHAR 'pg_catalog' default_collate_name Name of the default collation. VARCHAR 'ucs_basic' columns : Columns The view that describes the catalog information for columns is information_schema.columns . It lists the column...present in the database and has the following layout: Column Description Type Example table_catalog Name of the database containing the table (always the current database). VARCHAR 'm... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- DuckDB_% Metadata Functions – DuckDB 9338
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...view. For example, you can use a duckdb_ function call in the FROM clause of a SELECT statement, and you may refer to the columns of its returned resultset elsewhere in the statement, for example in the WHERE clause. Table functions are still function...duckdb_views (); The duckdb_views view returns views that are not marked as internal: SELECT * FROM duckdb_views ; duckdb_columns The duckdb_columns() function provides metadata about the columns available in the DuckDB instance. Column Description Ty...pe database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema_name The S... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Python Client API – DuckDB 9314
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...uckdb. CatalogException ¶ Bases: ProgrammingError duckdb. CoalesceOperator ( * args ) → duckdb.duckdb.Expression ¶ duckdb. ColumnExpression ( * args ) → duckdb.duckdb.Expression ¶ Create a column reference from the provided column name class duckdb. Co...ing.DuckDBPyType ¶ Create a decimal type with ‘width' and ‘scale' property description ¶ Get result set attributes, mainly column names df ( self : duckdb.duckdb.DuckDBPyConnection , * , date_as_object : bool = False ) → pandas.DataFrame ¶ Fetch a resu...ion object from the CSV file in ‘name' read_json ( self : duckdb.duckdb.DuckDBPyConnection , path_or_buffer : object , * , columns : Optional [ object ] = None , sample_size : Optional [ object ] = None , maximum_depth : Optional [ object ] = None , re... - https://man.mtool.work/duckdb/1.3/clients/python/reference/
- Complete API – DuckDB 8846
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...st char * query , duckdb_result * out_result ); void duckdb_destroy_result ( duckdb_result * result ); const char * duckdb_column_name ( duckdb_result * result , idx_t col ); duckdb_type duckdb_column_type ( duckdb_result * result , idx_t col ); duckdb..._statement_type duckdb_result_statement_type ( duckdb_result result ); duckdb_logical_type duckdb_column_logical_type ( duckdb_result * result , idx_t col ); idx_t duckdb_column_count ( duckdb_result * result ); idx_t duckdb_ro...w_count ( duckdb_result * result ); idx_t duckdb_rows_changed ( duckdb_result * result ); void * duckdb_column_data ( duckdb_result * result , idx_t col ); bool * duckdb_nullmask_data ( duckdb_result * result , idx_t col ); const cha... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Appender – DuckDB 8367
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...faster than using prepared statements or individual INSERT INTO statements. Appends are made in row-wise format. For every column, a duckdb_append_[type] call should be made, after which the row should be finished by calling duckdb_appender_end_row . A...const char * catalog , const char * schema , const char * table , duckdb_appender * out_appender ); idx_t duckdb_appender_column_count ( duckdb_appender appender ); duckdb_logical_type duckdb_appender_column_type ( duckdb_appender appender , idx_t col...appender appender ); duckdb_state duckdb_appender_destroy ( duckdb_appender * appender ); duckdb_state duckdb_appender_add_column ( duckdb_appender appender , const char * name ); duckdb_state duckdb_appender_clear_columns ( duckdb_appender appender );... - https://man.mtool.work/duckdb/1.3/clients/c/appender.html
- UNPIVOT Statement – DuckDB 8127
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...t Sitemap Live Demo Documentation / SQL / Statements Copy Markdown UNPIVOT Statement The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which...contains the name of the source column) and a VALUE column (which contains the value from the source column). DuckDB implements both the SQL Standard UNPIVOT syn...tax and a simplified UNPIVOT syntax. Both can utilize a COLUMNS expression to automatically detect the columns to unpivot. PIVOT_LONGER may also be used in place of the UNPIVOT keyword.... - https://man.mtool.work/duckdb/1.3/sql/statements/unpivot.html
- Struct Data Type – DuckDB 8091
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...tion Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Struct Data Type Conceptually, a STRUCT column contains an ordered list of columns called “entries”. The entries are referenced by name using strings. This document refe...rs to those entry names as keys. Each row in the STRUCT column must have the same keys. The names of the struct entries are part of the schema . Each row in a STRUCT column must have th...e same layout. The names of the struct entries are case-insensitive. STRUCT s are typically used to nest multiple columns into a single column, and the nested column can be of any type, including other STRUCT s and LIST s. STRUCT s are similar... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
DuckDB 1.3 Documentation / man.mtool.work