Re: alter role - superuser - permissions - Mailing list pgsql-novice

From Mike
Subject Re: alter role - superuser - permissions
Date
Msg-id CAECVvTWqp0_n5hSG8FgzOsgzYONOX8mQZTuBmYreiFoJ2s2sxg@mail.gmail.com
Whole thread Raw
In response to Re: alter role - superuser - permissions  (Mike <1100100@gmail.com>)
List pgsql-novice
I didn't get the copy command to work today; however, I did figure out
you can copy a massive list of values and put the following command in
front and paste that into a psql prompt ---

insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');
insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');
insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');
insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');
insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');
insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');
insert into accounts (employ_last, employ_first, service, website,
userid, password) VALUES ('aaa','bbb','ccc','ddd','eee','fff');

Noobish, yes; a happy discovery, yes.  :-)


pgsql-novice by date:

Previous
From: Mike
Date:
Subject: Re: alter role - superuser - permissions
Next
From: Marc Richter
Date:
Subject: How to display ALL privileges for a role using SQL?