On 6/17/19 1:58 AM, John Mikel wrote:
hi again
here is my query
*select A.table_name as "table_name",A.domain_name as "domain",*
* format_type(c.atttypid, c.atttypmod) AS data_type ,A.column_name as
"column_name",*
* A.is_nullable as "nullable",A.column_default as "default"*
* from inf
hi again
here is my query
*select A.table_name as "table_name",A.domain_name as "domain",*
* format_type(c.atttypid, c.atttypmod) AS data_type ,A.column_name as
"column_name",*
* A.is_nullable as "nullable",A.column_default as "default"*
* from information_schema.columns A inner join pg_a
I wrote:
> ... I'd suggest recasting this as a join between
> pg_catalog and pg_attribute, which would make the join condition
> just "where c.oid = a.attrelid".
Sigh, that should be "between pg_class and pg_attribute" of course.
I'm really only firing on one cylinder today :-(
"Peter J. Holzer" writes:
> On 2019-06-16 18:03:02 +0200, John Mikel wrote:
>> here is my query
>> select A.table_name as "table_name",A.domain_name as "domain",
>> format_type(c.atttypid, c.atttypmod) AS data_type ,A.column_name as
>> "column_name",
>> A.is_nullable as "nullable",A.colum
On 2019-06-16 18:03:02 +0200, John Mikel wrote:
> hi again
> here is my query
> select A.table_name as "table_name",A.domain_name as "domain",
> format_type(c.atttypid, c.atttypmod) AS data_type ,A.column_name as
> "column_name",
> A.is_nullable as "nullable",A.column_default as "default"
hi again
here is my query
*select A.table_name as "table_name",A.domain_name as "domain",*
* format_type(c.atttypid, c.atttypmod) AS data_type ,A.column_name as
"column_name",*
* A.is_nullable as "nullable",A.column_default as "default"*
* from information_schema.columns A inner join pg_att
On 6/13/19 8:14 AM, John Mikel wrote:
* hi ,
i am here to tell you that this test in query is not working when the
table name in the database or schema name contain space
a.table_name::regclass=b.attrelid
a is information_schema.columns
b is pg_attribute
trying this in two differ
* hi , i am here to tell you that this test in query is not working when
the table name in the database or schema name contain
space a.table_name::regclass=b.attrelid a is information_schema.columns b
is pg_attribute trying this in two different databases the first database
contain table with