A. down click on Login/Group Roles
and you will see all the users and/or roles
OR
B. right click on Login/Group Roles
and you will see the option to Create
Then place the cursor on Create and you will see the
option for Login/Group Role...
Melvin Davidson 🎸
I reserve the right to
ting pgadmin?
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Monday, January 28, 2019, 8:41:27 PM EST, Steve H
>Ok, but what about the apt repo?
The apt repo for PgAdmin does not contain postgreSQl.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a
>And on the wiki it says pgAdmin III is bundled with the Windows installer,
Basically, you have things backwards.PgAdmin is bundled with PostgreSQL in some
distributions, but if youdownload from www.pgadmin.org/download/ then you only
get PgAdmin and nothing else.
Melvin Davidson 🎸
27;first text value', 1, 11),
)'secon b', 'first text value', 2, 22);
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folk
Dave,
I am in favor of "version number to 3.0 for the next release".
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
E 'pgadmin%'
AND relkind = 'r'
AND d.description IS NOT NULL
AND col.attnum >= 0
ORDER BY 1, 2, 4;
SELECT p.oid,
p.proname AS function,
d.description AS comment
FROM pg_proc p
JOIN pg_description d ON d.objoid = p.oid
WHERE p.proname LIKE 'pgad
alogs and views;
Your definition is a behavior change from PgAdmin III, which DID NOT show every
"system object" per your definition". It only showed USER types as permy query.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is en
'c'
)
SELECT *
FROM pg_type
WHERE oid in (SELECT reltype
FROM types)
ORDER BY typname;
No need to duplicate everything else.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtub
Dave,
I just installed the browser version of PgAdmin 4 desktop. Excellent! It starts
up almost immediately and is very responsive. So plus one upvote for this make.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you
Stefan,
I am not PgAdmin support, but I've attached a bash script and sql query that
may helpin searching for column names.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk
conf. Simply having an easy way to change values does not mean
you will
be protected from setting them too high(or wrong). EG: setting work_mem to 1GB
will be very bad.It is better to learn and understand WHY you need to change
values, than just having
an easy way to do so.
Melvin Davidson 🎸
I reser
Limit".
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Thursday, January 4, 2018, 11:45:25 AM EST, velvetpix
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Monday, November 6, 2017, 10:23:04 AM EST, Cherio
wrote
You don't need buttons.
Just go to File Preferences SQL Editor and change Auto commit? to False
and Auto rollback? to False
Or whatever you prefer.That is what those options are for!
Or learn how to use a TRANSACTION in PostgreSQL.IE: BEGIN;
Melvin Davidson 🎸
I reserve the
Please note, I am not PgAdmin4 support.
However, it seems to me that what you want is handled in File Preferences
SQL Editor
Options Auto commit? True/False
Auto rollback? True/False
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
pport. I have forwarded for you
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
s url.
wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On M
I am not pgadmin support, but if you are a superuser,you can get the password
with:
SELECT rolname,
rolpassword
FROM pg_authid
WHERE rolname = 'username';
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely
transaction. That is a major change. As a DBA, I need to be able
to kill _sessions_. I can get around that withSQL, but WHY the change? Please,
STOP changing how PgAdmin works!
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you
acter are missing from the Query screen. EG: Ln 5, Col 4, Ch 49
In fact, thestatus line is gone altogether.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Ho
is a change from PgAdmin IIIwhere it was displayed
until another query is run. I believe the latter is the preferred option.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley
You indicated you are using PgAdmin4 v1.5.
The latest supported version for Windows is v1.6.
I strongly suggest you download and install that version.
www.postgresql.org/ftp/pgadmin/pgadmin4/v1.6/windows/
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my
Python environment vars.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Thursday, September 14, 2017, 2:11:38 AM EDT
are referring to importing an object/function, then just open a SQL
window. From there you can export sql queries or load a sql file.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk
>can´t see the way for adding a server.
Hmm, on bottom right of the image you sent, there is a big icon that says "Add
New Server". Have you tried clicking on that?
Melvin Davidson 🎸
Cell 720-320-0155
I reserve the right to fantasize. Whether or not you
wish to share
Details:Windows 10 HomeProcessor: Intel Pentium CPU G3220 3.0GhzGPU: AMD
Radeon HD 6450
Memory: 8.00 GB *(3.47 GB usable)32-bit O/SDual monitors
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk
that as of 4 v1.5 .
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
On Friday, June 23, 2017, 2:47:51 PM EDT, Paragon Corporat
decided you will no longer
use PgAdmin and instead prefer the "alternatives", I am sure everyoneelse on
this list will be just as happy to see you depart.
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.y
tetime.html
andhttps://www.postgresql.org/docs/9.6/static/sql-createtable.html
Melvin Davidson 🎸
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
O
30 matches
Mail list logo
