Re: How to get the data from the query

Running this query: draft=# SELECT DISTINCT column_name, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_precision_radix, numeric_scale, is_nullabl e, column_default, ordinal_position, CASE WHEN column_name IN (SELECT ccu.column_name FROM information_schema.

Re: How to get the data from the query

Now this query still works: [code] draft=# SELECT DISTINCT column_name, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_precision_radix, numeric_scale, is_nullabl e, column_default, ordinal_position FROM information_schema.columns WHERE table_name='leagues'

Re: How to get the data from the query

Hi, David, On Sat, Apr 26, 2025 at 8:06 PM David G. Johnston wrote: > > On Saturday, April 26, 2025, Igor Korot wrote: >> >> but the size comes out "" (empty) >> > > What is the value you are expecting? Expecting to have "100". What is the minimal table definition (i.e., a one or few column