From: | Mike <1100100(at)gmail(dot)com> |
---|---|
To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: alter role - superuser - permissions |
Date: | 2016-09-05 03:14:09 |
Message-ID: | CAECVvTWqp0_n5hSG8FgzOsgzYONOX8mQZTuBmYreiFoJ2s2sxg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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. :-)
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Richter | 2016-09-05 13:13:00 | How to display ALL privileges for a role using SQL? |
Previous Message | Mike | 2016-09-04 22:27:16 | Re: alter role - superuser - permissions |