Re: question on the information_schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm not stupid, I added some columns before sending the query. I'm trying to write a query that returns the name and other information about the columns of a database. the query that is sent is the following

select * from information_schema.columns col
where col.table_schema!='pg_catalog'and col.table_schema!='information_schema'


if i sent the query  as "postgres", the result is a table that contain the the right column list. If I sent the query as "ssaa", the result is an empty table.
I must to be able to retrieve the list of tables as a user "ssaa".
-- 
Saluti,
Salvatore Barone

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux