2024-08-16 04:38:26, "Anthony DeBarros" wrote:
Howdy,
On Thu, Aug 15, 2024 at 2:35 AM 毛毛 wrote:
Hey there,
I just found out my pgAdmin is version 7.6, while the current version is 8.6.
Looks like it's time for an upgrade!
The notification I got had a link to the EDB site w
Hey there,
I just found out my pgAdmin is version 7.6, while the current version is 8.6.
Looks like it's time for an upgrade!
The notification I got had a link to the EDB site with a bunch of PostgreSQL
installers listed. Thing is, I don't want to mess up my database. So I figured
it'd be smar
elf hassle in the future:
ALTER ROLE "Baba" RENAME TO baba;
Also, use a .pgpass file: https://www.postgresql.org/docs/14/libpq-pgpass.html
On Sun, Jun 23, 2024 at 3:22 PM 毛毛 wrote:
Thank you! You are right!
After putting quotes around the username, it works!
在 2024-06-
Thank you! You are right!
After putting quotes around the username, it works!
在 2024-06-24 02:47:44，"David G. Johnston" 写道：
On Sun, Jun 23, 2024, 11:43 毛毛 wrote:
Hi,
I tried to create a user with CREATEDB permission.
Then I wanted to run command line tool `crea
Hi,
I tried to create a user with CREATEDB permission.
Then I wanted to run command line tool `createdb` with this newly created user.
So I ran SQL first to create a user:
```
CREATE USER Baba WITH PASSWORD 'xxx' CREATEDB;
```
Then I run the following command on PowerShell on Windows 10:
Hi,
Do we have a rule by follow which one can accurately info the output of a
SELECT statment FROM a table with floating-point data type?
I am working with PostgreSQL 16 and pgAdmin 7.6.
Here is my SQL script:
```
CREATE TABLE TEST (REAL_COLUMN real);
INSERT INTO TEST
VALUES (12345.12345
