Re: Why not used standart SQL commands?

2022-01-09 Thread Nicklas Avén
Den 2022-01-08 kl. 19:25, skrev Ali Koca: Hello, I'm seeing \dt used for "show tables", \l used for "show databases". Why not standart SQL syntax words? Why specified PostgreSQL commands? I can't figure out that. Ali The psql backslash commands is just helper commands that wraps the actual

Re: create database hangs forever on WSL - autovacuum deadlock?

2022-01-09 Thread Thomas Munro
On Sun, Jan 9, 2022 at 2:15 PM Alicja Kucharczyk wrote: > sob., 8 sty 2022 o 22:40 Thomas Munro napisał(a): >> On Sat, Jan 8, 2022 at 8:11 PM Alicja Kucharczyk >> wrote: >> > this is postgres running on windows wsl: PostgreSQL 14.1 (Ubuntu >> > 14.1-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compi

Re: The postgres server don't work

2022-01-09 Thread Дмитрий Иванов
Рад слышать это! -- С уважением, Дмитрий! вс, 9 янв. 2022 г. в 18:42, Mohammed falih : > It worked ! > thank you so much , all of you > for your efforts and time > best wishes to you > > On Sun, 9 Jan 2022, 3:51 pm Дмитрий Иванов, wrote: > >> You need to open the folder containing the file and

Re: The postgres server don't work

2022-01-09 Thread Mohammed falih
It worked ! thank you so much , all of you for your efforts and time best wishes to you On Sun, 9 Jan 2022, 3:51 pm Дмитрий Иванов, wrote: > You need to open the folder containing the file and (you must be an > administrator) > Open the file in an editor running as an administrator. > OR > Righ

Re: The postgres server don't work

2022-01-09 Thread Дмитрий Иванов
You need to open the folder containing the file and (you must be an administrator) Open the file in an editor running as an administrator. OR Right click on the file "C:\Program Files\PostgreSQL\12\scripts\runpsql.bat" -> Properties-> Security. Select the "Users" group, click "Change" and give wri

Re: The postgres server don't work

2022-01-09 Thread Mohammed falih
yes exactly I added chcp 1252 line but when I try to save the changes . an error pop out says "you don't have the permission to open this file ,see the owner of the file or an administrator to obtain permission" even though I went to properties/security/myaccount and made it full control On Sun,

Re: The postgres server don't work

2022-01-09 Thread Mohammed falih
yes sorry I wrote this sentence before try the solution you offered yes by deleting the changes (the Autorun) and thank you so much for your efforts ,I have gone through this solution before but didn't help me to solve the problem ,when I go to command prompt as administrator and insert chcp 12

Re: The postgres server don't work

2022-01-09 Thread Mohammed falih
thank you for your efforts I added chcp 1252 line but when I try to save the changes . an error pop out says "you don't have the permission to open this file ,see the owner of the file or an administrator to obtain permission" even though I went to properties/security/mylaptopaccount and made it fu