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.
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'
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
On Saturday, April 26, 2025, Igor Korot wrote:
> but the size comes out "" (empty)
>
>
What is the value you are expecting? What is the minimal table definition
(i.e., a one or few column table) that would produce this expected value?
What does psql show if you use it to output the query against
Hi, ALL,
[code]
std::wstring query2 = L"SELECT DISTINCT column_name, data_type,
character_maximum_length, character_octet_length, numeric_precision,
numeric_precision_radix, numeric_scale, is_nullable, column_default,
CASE WHEN column_name IN (SELECT ccu.column_name FROM
information_schema.con
