Re: [GENERAL] User groups
On Thursday 23 February 2006 20:37, Russell Denney wrote:
Any user groups in the Tampa, St. Petersburg, Florida area? Anyone
interested in starting a group? I am new to PostgreSQL and many aspects
of programming, but I would very much like to meet with those that have
the same interests, regardless of programming skills.
There isn't currently a user group in the Tampa area, but if you're interested
in starting one I know there are a couple companies using postgresql in that
area so I think you could find some other attendees. I have family in that
area, so I'd certainly make an attempt to swing down from Gainesville; you
might also send an invite out to any members of the Tampa PHP users group
(http://php.meetup.com/315/events/?eventId=4836735action=detail), there are
a couple of folks who belong to that who are pg fans. You could make a site
on meetup like the php folks did, or maybe make a site at the pg user group
site. http://pugs.postgresql.org/
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
[GENERAL] User groups
Any user groups in the Tampa, St. Petersburg, Florida area? Anyone interested in starting a group? I am new to PostgreSQL and many aspects of programming, but I would very much like to meet with those that have the same interests, regardless of programming skills. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] user/groups query ?
Thank you very much !
- Original Message -
From: John DeSoi [EMAIL PROTECTED]
To: Zlatko Matić [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Monday, June 20, 2005 3:40 AM
Subject: Re: [GENERAL] user/groups query ?
On Jun 19, 2005, at 3:56 PM, Zlatko Matić wrote:
How to make a query that will include information both about user and
group (or groups) he belongs to ?
Thanks.
Turning on the ECHO_HIDDEN feature in psql shows how to do this.
\set ECHO_HIDDEN 1
\du user1
* QUERY **
SELECT u.usename AS User name,
u.usesysid AS User ID,
CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, create
database' AS pg_catalog.text)
WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text)
WHEN u.usecreatedb THEN CAST('create database' AS
pg_catalog.text)
ELSE CAST('' AS pg_catalog.text)
END AS Attributes,
ARRAY(SELECT g.groname FROM pg_catalog.pg_group g WHERE u.usesysid =
ANY(g.grolist)) as Groups
FROM pg_catalog.pg_user u
WHERE u.usename ~ '^user1$'
ORDER BY 1;
**
List of users
User name | User ID | Attributes | Groups
---+-++
user1 | 100 || {test}
(1 row)
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---(end of broadcast)---
TIP 8: explain analyze is your friend
[GENERAL] user/groups query ?
Hello. How to make a query that will include information both about user and group (or groups)he belongs to? Thanks.
Re: [GENERAL] user/groups query ?
On Jun 19, 2005, at 3:56 PM, Zlatko Mati wrote:
How to make a query that will include information both about user and
group (or groups)he belongs to?
Thanks.
Turning on the ECHO_HIDDEN feature in psql shows how to do this.
\set ECHO_HIDDEN 1
\du user1
* QUERY **
SELECT u.usename AS User name,
u.usesysid AS User ID,
CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, create
database' AS pg_catalog.text)
WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text)
WHEN u.usecreatedb THEN CAST('create database' AS
pg_catalog.text)
ELSE CAST('' AS pg_catalog.text)
END AS Attributes,
ARRAY(SELECT g.groname FROM pg_catalog.pg_group g WHERE u.usesysid =
ANY(g.grolist)) as Groups
FROM pg_catalog.pg_user u
WHERE u.usename ~ '^user1$'
ORDER BY 1;
**
List of users
User name | User ID | Attributes | Groups
---+-++
user1 | 100 || {test}
(1 row)
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Re: [GENERAL] user groups
Hi. Thank you for information. How can I dump_all from pgAdmin III ? Thanks. - Original Message - From: John DeSoi [EMAIL PROTECTED] To: Zlatko Mati [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Sent: Wednesday, June 15, 2005 1:25 AM Subject: Re: [GENERAL] user groups On Jun 14, 2005, at 6:17 PM, Zlatko Mati wrote: When I create some user group and set permissions and then dump (backup) database and install on some other computer, what will happen with groups and permissions? Should they exist on other computers too ? I don't understand whether permissions to groups are something that is integrated in the database or it is just attached to database ? Greetings, If you use pg_dumpall, then all the user and group information will be included in the backup file. See http://www.postgresql.org/docs/8.0/interactive/app-pg-dumpall.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] user groups
When I create some user group and set permissions and then dump (backup) database and install on some other computer, what will happen with groups and permissions? Should they exist on other computers too ? I don't understand whether permissions to groups are something that is integrated in the database or it is just attached to database ? Greetings, Zlatko
Re: [GENERAL] user groups
On Jun 14, 2005, at 6:17 PM, Zlatko Mati wrote: When I create some user group and set permissions and then dump (backup) database and install on some other computer, what will happen with groups and permissions? Should they exist on other computers too ? I don't understand whether permissions to groups are something that is integrated in the database or it is just attached to database ? Greetings, If you use pg_dumpall, then all the user and group information will be included in the backup file. See http://www.postgresql.org/docs/8.0/interactive/app-pg-dumpall.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
