Results of 1 - 10 of about 17 for comment (0.002 sec.)
- COMMENT ON Statement 14570
- The COMMENT ON statement allows adding metadata to catalog entries (tables, columns, etc.). It follows the PostgreSQL syntax . Examples Create a comment on a TABLE : COMMENT ON TABLE test_table IS 'very nice table'; Create a comment on a CO
...LUMN : COMMENT ON COLUMN test_table.test_table_column IS 'very nice column'; Create a comment on a VIEW : COMMENT ON VIEW test_view IS 'v...ery nice view'; Create a comment on an INDEX : COMMENT ON INDEX test_index IS 'very nice index'; Create a comment on a SEQUENCE : COMMENT ON SEQUENCE test_...sequence IS 'very nice sequence'; Create a comment on a TYPE : COMMENT ON TYPE test_type IS 'very nice type'; Create a comment on a MACRO : COMMENT ON MACRO test_macro IS 'v... - https://man.mtool.work/duckdb/2.0/sql/statements/comment_on.html
- DuckDB_% Metadata Functions 11293
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...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 is built-in, false if it is user-defi...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...te , pragma , macro , table_macro VARCHAR description Description of this function, or NULL if none is registered. VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string key–value pairs. MAP(VARCHAR, VARCHAR) return... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Schema 9449
- Types It is important to use the correct type for encoding columns (e.g., BIGINT , DATE , DATETIME ). While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use mor
...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...ncode 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)) FROM Comment;...Joining on Strings We illustrate the difference caused by joining on different types by computing a self-join on the LDBC Comment table at scale factor 100 . The table has 64-bit integer identifiers used as the id attribute of each row. We perform the... - https://man.mtool.work/duckdb/2.0/guides/performance/schema.html
- Syntax Highlighting 8414
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
...ent Default color Keywords keyword green Numeric constants numeric_constant yellow String constants string_constant yellow Comments comment gray Errors error red Continuation continuation gray Continuation (Selected) continuation_selected green Colors a...keyword brightred bold .highlight_colors numeric_constant white .highlight_colors string_constant white .highlight_colors comment cyan .highlight_colors error yellow .highlight_colors continuation blue .highlight_colors continuation_selected brightblue... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- FROM and JOIN Clauses 8138
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...bles 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_regionkey I...NTEGER NOT NULL, n_comment VARCHAR(152), FOREIGN KEY (n_regionkey) REFERENCES l_regions(r_regionkey) ); Return the regions for the nations: SELECT n....simpler USING syntax can be used: CREATE TABLE l_regions (regionkey INTEGER NOT NULL PRIMARY KEY, name CHAR(25) NOT NULL, comment VARCHAR(152)); CREATE TABLE l_nations (nationkey INTEGER NOT NULL PRIMARY KEY, name CHAR(25) NOT NULL, regionkey INTEGER N... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- CSV Auto Detection 8104
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...r Delimiter delim , Quote Quote character quote " Escape Escape escape \ NewLineDelimiter New-line delimiter new_line \r\n Comment Comment character comment # SkipRows Number of rows skipped skip 1 HasHeader Whether the CSV has a header header true Colu... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- Limits 8104
- This page contains DuckDB's built-in limit values. To check the value of a setting on your system, use the current_setting function. Limit Values Limit Default value Configuration option Comment Array size 100000 - BLOB size 4 GB - Expressi
... - https://man.mtool.work/duckdb/2.0/operations_manual/limits.html
- CSV Import 8052
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...t (e.g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection of the schema. 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/2.0/data/csv/overview.html
- Unit Tester Configuration 8017
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...checkpoint on database shutdown --checkpoint-wal-size <num> Size in bytes after which to trigger automatic checkpointing --comment <string> Extra free form comment line --data-dir <path> Root dir for test data; default WORKING_DIR/data. Relative values... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Benchmarks 8017
- For several of the recommendations in our performance guide, we use microbenchmarks to back up our claims. For these benchmarks, we use datasets from the TPC-H benchmark and the LDBC Social Network Benchmark's BI workload . Datasets We use
...the LDBC BI SF300 dataset'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/2.0/guides/performance/benchmarks.html
DuckDB 2.0 Documentation / man.mtool.work