Yogi Yang 007 wrote:
3. Retrieve list of all Group Roles
4. Retrieve list of all Login Roles
there is no difference between these, except in usage.
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/p
On Thu, Mar 25, 2010 at 1:26 AM, John R Pierce wrote:
> Yogi Yang 007 wrote:
>
>> Hello,
>>
>> I am new to pgSQL. I would like to know if there is a way to do the
>> following using pure SQL:
>> 1. Retrieve list of all Tables in a database
>> 2. Retrieve list of all Functions, Triggers, Sequences
Yogi Yang 007 wrote:
Hello,
I am new to pgSQL. I would like to know if there is a way to do the
following using pure SQL:
1. Retrieve list of all Tables in a database
2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
3. Retrieve list of all Group Roles
4. Retrieve list of all
Hi Yogi Yang,
Psql is a very strong tool, and easy to use. Please find the answers for
your queries
>>1. Retrieve list of all Tables in a database
>>2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
>>3. Retrieve list of all Group Roles
postgres=#\d{t|i|s|v|S|g|n}
you can use a
Hello,
I am new to pgSQL. I would like to know if there is a way to do the
following using pure SQL:
1. Retrieve list of all Tables in a database
2. Retrieve list of all Functions, Triggers, Sequences, Views, etc.
3. Retrieve list of all Group Roles
4. Retrieve list of all Login Roles
5. Struct
