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=4836735&action=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: 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
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
[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
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: 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
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
[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