Results of 1 - 10 of about 370 for comment (0.004 sec.)
- COMMENT ON Statement – DuckDB 18061
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Statements Copy Markdown COMMENT ON Statement The COMMENT ON statement allows adding metadata to catalog entries (tables, columns, etc.). It follows the Po...stgreSQL syntax . Examples Create a comment on a TABLE : COMMENT ON TABLE test_table IS 'very nice table' ; Create a comment on a COLUMN : COMMENT ON COLUMN test_tabl... - https://man.mtool.work/duckdb/1.3/sql/statements/comment_on.html
- DuckDB_% Metadata Functions – DuckDB 12555
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...T column_name The SQL name of the column. VARCHAR column_index The unique position of the column within its table. INTEGER comment A comment created by the COMMENT ON statement . VARCHAR internal true if this column built-in, false if it is user-defined...HAR database_oid The internal identifier of the database. VARCHAR path The file path associated with the database. VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) intern... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Schema – DuckDB 8634
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...crobenchmark: Using Timestamps We illustrate the difference in aggregation speed using the creationDate column of the LDBC Comment table on scale factor 300 . This table has approx. 554 million unordered timestamp values. We run a simple aggregation que...the values and run the query using the extract datetime function : SELECT avg ( extract ( 'day' FROM creationDate )) FROM Comment ; Second, we use the VARCHAR type and use string operations: SELECT avg ( CAST ( creationDate [ 9 : 10 ] AS INTEGER )) FRO... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Limits – DuckDB 5832
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...y Markdown Limits This page contains DuckDB's built-in limit values. Limit Values Limit Default value Configuration option Comment Array size 100000 - BLOB size 4 GB - Expression depth 1000 max_expression_depth Memory allocation for a vector 128 GB - Me...emory directory Documentation Operations Copy Markdown Limits contains built-in values Values Default Configuration option Comment Expression expression allocation vector 関連するページ Out of Memory Errors Pragmas Data Chunks Directly Reading Files SET... - https://man.mtool.work/duckdb/1.3/operations_manual/limits.html
- Syntax Highlighting – DuckDB 5647
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...mponents that can be configured. Type Command Default color Keywords .keyword green Constants ad literals .constant yellow Comments .comment brightblack Errors .error red Continuation .cont brightblack Continuation (Selected) .cont_sel green The compone...\033[97m For example, here is an alternative set of syntax highlighting colors: .keyword brightred .constant brightwhite .comment cyan .error yellow .cont blue .cont_sel brightblue If you wish to start up the CLI with a different set of colors every ti... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- FROM and JOIN Clauses – DuckDB 5647
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...from the TPC-H schema: CREATE TABLE l_regions ( r_regionkey INTEGER NOT NULL PRIMARY KEY , r_name CHAR ( 25 ) NOT NULL , r_comment VARCHAR ( 152 ) ); CREATE TABLE l_nations ( n_nationkey INTEGER NOT NULL PRIMARY KEY , n_name CHAR ( 25 ) NOT NULL , n_reg...ionkey INTEGER NOT NULL , n_comment VARCHAR ( 152 ), FOREIGN KEY ( n_regionkey ) REFERENCES l_regions ( r_regionkey ) ); Return the regions for the nations: S... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- CSV Import – DuckDB 5365
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...es, as a struct (e.g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection. STRUCT (empty) comment Character used to initiate comments. Lines starting with a comment character (optionally preceded by space characters) are...completely ignored; other lines containing a comment character are parsed only up to that point. VARCHAR (empty) compression Method used to compress CSV files. By default this... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Benchmarks – DuckDB 5092
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...om the TPC-H benchmark and the LDBC Social Network Benchmark's BI workload . Data Sets We use the LDBC BI SF300 data set's Comment table (20 GB .tar.zst archive, 21 GB when decompressed into .csv.gz files), while others use the same table's creationDate... - https://man.mtool.work/duckdb/1.3/guides/performance/benchmarks.html
- CSV Auto Detection – DuckDB 4995
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...Description Example Delimiter Delimiter , Quote Quote character " Escape Escape \ NewLineDelimiter New-line delimiter \r\n Comment Comment character # SkipRows Number of rows skipped 1 HasHeader Whether the CSV has a header true Columns Column types enc... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Summarize – DuckDB 4898
- 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
...ion Query Extensions SQL Introduction Statements Overview ANALYZE ALTER TABLE ALTER VIEW ATTACH and DETACH CALL CHECKPOINT COMMENT ON COPY CREATE INDEX CREATE MACRO CREATE SCHEMA CREATE SECRET CREATE SEQUENCE CREATE TABLE CREATE VIEW CREATE TYPE DELETE...BACK RETURN 4 NULL NULL NULL NULL NULL 6001215 0.0% l_shipmode VARCHAR AIR TRUCK 7 NULL NULL NULL NULL NULL 6001215 0.0% l_comment VARCHAR Tiresias zzle? furiously iro 3558599 NULL NULL NULL NULL NULL 6001215 0.0% Using SUMMARIZE in a Subquery SUMMARIZE... - https://man.mtool.work/duckdb/1.3/guides/meta/summarize.html
DuckDB 1.3 Documentation / man.mtool.work