Re: alter role - superuser - permissions

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. :-)

In response to

Browse pgsql-novice by date

  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