raghu ram-4 wrote
>>
> If you are executing the SQL statement with "postgres" user
> [Superuser],then you will see all information related to all objects
> without any restrictions of the Ownership.
>
> If you are executing the SQL Statements with "saas" user
> [Non-Superuser],then you will see th
Salvatore Barone wrote
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema |Nome| Tipo | Proprietario |
> Dimensione | Descrizione
> ++-+
2013/8/23 Salvatore Barone
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema |Nome| Tipo | Proprietario | Dimensione
> | Descrizione
>
> ++-+
2013/8/23 Salvatore Barone
> This is the output of \d from psql. I logged in as "ssaa"
>
> Lista delle relazioni
> Schema |Nome| Tipo | Proprietario | Dimensione
> | Descrizione
>
> ++-+
This is the output of \d from psql. I logged in as "ssaa"
Lista delle relazioni
Schema |Nome| Tipo | Proprietario |
Dimensione | Descrizione
++-+--++-
publ
On Fri, Aug 23, 2013 at 8:12 AM, Salvatore Barone wrote:
> I'm not stupid,
>
No one said you were. These lists see people of a wide range of skillsets
and expertise. In this case it might not be the answer for your issue, but
David's suggestion might help someone else having a similar problem i
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.t
On Fri, Aug 23, 2013 at 8:02 AM, Salvatore Barone wrote:
> On 23/08/2013 16:57, bricklen wrote:
>
> select *
> from information_schema.columns
> where table_schema not in ('information_schema','pg_catalog')
>
> Both queries, whether to send as user "ssaa", ie the user that I use
> daily, return
On 23/08/2013 16:57, bricklen wrote:
> select *
> from information_schema.columns
> where table_schema not in ('information_schema','pg_catalog')
Both queries, whether to send as user "ssaa", ie the user that I use
daily, return an empty table. If sending as user "postgres" instead,
they return the
Salvatore Barone wrote
> Hi all,
> I created a database named "test" with the user "postgres" and I have
> given all privileges on database "test" to a user that I use daily,
> called "ssaa".
> By submitting, as user "ssaa", to "test" database the «select * from
> information_schema.columns with wh
On Fri, Aug 23, 2013 at 7:49 AM, Salvatore Barone wrote:
> Hi all,
> I created a database named "test" with the user "postgres" and I have
> given all privileges on database "test" to a user that I use daily, called
> "ssaa".
> By submitting, as user "ssaa", to "test" database the «select * from
Hi all,
I created a database named "test" with the user "postgres" and I have
given all privileges on database "test" to a user that I use daily,
called "ssaa".
By submitting, as user "ssaa", to "test" database the «select * from
information_schema.columns with where col.table_schema! = 'Pg_catalog
12 matches
Mail list logo
