How to connect to PostgreSQL

You need to install HeidiSQL with dlls you don't have yet. Please use the latest installer from the nightly builds section.

Then, in the session screen, ensure you have one database you want to work with in the "Database(s)" box.

/* Delimitador cambiado a ; */
/* Conectando a localhost por PostgreSQL (experimental), usuario postgres, usando contraseña: Yes ... */
SELECT VERSION();
/* Conectado. ID de Hilo: 2728 */
SET statement_timeout TO 0;
SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - pg_postmaster_start_time())::INTEGER;
SELECT "schema_name" FROM "information_schema"."schemata" ORDER BY "schema_name";
/* Entrando a la sesión "localhost PGSQL" */
SELECT *, pg_table_size(CONCAT(t.TABLE_SCHEMA, '.', t.TABLE_NAME)) AS data_length, pg_relation_size(CONCAT(t.TABLE_SCHEMA, '.', t.TABLE_NAME)) AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_class" c ON c.relname=t.table_name LEFT JOIN "pg_namespace" n ON (n.oid = c.relnamespace) WHERE t."table_schema"='public';
SET SCHEMA 'public';

/* Delimitador cambiado a ; */
/* Conectando a localhost por PostgreSQL (experimental), usuario postgres, usando contraseña: Yes ... */
SELECT VERSION();
/* Conectado. ID de Hilo: 2794 */
SET statement_timeout TO 0;
SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - pg_postmaster_start_time())::INTEGER;
SET SCHEMA 'sapcine';
/* Entrando a la sesión "localhost PGSQL" */
SELECT *, pg_table_size(CONCAT(t.TABLE_SCHEMA, '.', t.TABLE_NAME)) AS data_length, pg_relation_size(CONCAT(t.TABLE_SCHEMA, '.', t.TABLE_NAME)) AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_class" c ON c.relname=t.table_name LEFT JOIN "pg_namespace" n ON (n.oid = c.relnamespace) WHERE t."table_schema"='sapcine';

This fulfills a request like:
SELECT *, pg_table_size(t.TABLE_SCHEMA || '.' || t.TABLE_NAME) AS data_length
, pg_relation_size(t.TABLE_SCHEMA || '.' || t.TABLE_NAME) AS index_length, c.reltuples, obj_description(c.oid) AS COMMENT
FROM "information_schema"."tables" AS t
LEFT JOIN "pg_class" c ON c.relname=t.table_name
LEFT JOIN "pg_namespace" n ON (n.oid = c.relnamespace);

CREATE TABLE "users_info_ext" (
"uin" TEXT NOT NULL,
"pass" TEXT NULL,
"ulock" SMALLINT NULL,
"llog" TEXT NULL,
"iadr" TEXT NULL,
"bcst" SMALLINT NULL,
"cdate" TEXT NULL,
"cpass" SMALLINT NULL,
"nick" TEXT NULL,
"frst" TEXT NULL,
"last" TEXT NULL,
"email1" TEXT NULL,
"email2" TEXT NULL,
"email3" TEXT NULL,
"e1publ" SMALLINT NULL,
"gmtoffs" SMALLINT NULL,
"auth" SMALLINT NULL,
"sex" SMALLINT NULL,
"age" SMALLINT NULL,
"bday" SMALLINT NULL,
"bmon" SMALLINT NULL,
"byear" SMALLINT NULL,
"waddr" TEXT NULL,
"wcity" TEXT NULL,
"wstate" TEXT NULL,
"wcountry" INTEGER NULL,
"wcompany" TEXT NULL,
"wtitle" TEXT NULL,
"wocup" SMALLINT NULL,
"wdepart" TEXT NULL,
"wphon" TEXT NULL,
"wfax" TEXT NULL,
"wpager" TEXT NULL,
"wzip" TEXT NULL,
"wweb" TEXT NULL,
"notes" TEXT NULL,
"haddr" TEXT NULL,
"hcity" TEXT NULL,
"hstate" TEXT NULL,
"hcountry" INTEGER NULL,
"hphon" TEXT NULL,
"hfax" TEXT NULL,
"hcell" TEXT NULL,
"hzip" TEXT NULL,
"hweb" TEXT NULL,
"nnotes" TEXT NULL,
"lang1" SMALLINT NULL,
"lang2" SMALLINT NULL,
"lang3" SMALLINT NULL,
"hpage_cf" SMALLINT NULL,
"hpage_cat" INTEGER NULL,
"hpage_txt" TEXT NULL,
"wdepart2" TEXT NULL,
"past_num" SMALLINT NULL,
"past_ind1" INTEGER NULL,
"past_key1" TEXT NULL,
"past_ind2" INTEGER NULL,
"past_key2" TEXT NULL,
"past_ind3" INTEGER NULL,
"past_key3" TEXT NULL,
"int_num" SMALLINT NULL,
"int_ind1" INTEGER NULL,
"int_key1" TEXT NULL,
"int_ind2" INTEGER NULL,
"int_key2" TEXT NULL,
"int_ind3" INTEGER NULL,
"int_key3" TEXT NULL,
"int_ind4" INTEGER NULL,
"int_key4" TEXT NULL,
"aff_num" SMALLINT NULL,
"aff_ind1" INTEGER NULL,
"aff_key1" TEXT NULL,
"aff_ind2" INTEGER NULL,
"aff_key2" TEXT NULL,
"aff_ind3" INTEGER NULL,
"aff_key3" TEXT NULL,
"iphide" SMALLINT NULL,
"webaware" SMALLINT NULL,
PRIMARY KEY ("uin")
);

SELECT "uin" , LEFT("pass",256) pass, "ulock"
-- , LEFT("llog", 256) yyy
FROM "public"."users_info_ext";

SELECT "uin" , LEFT("pass",256) pass, "ulock"
, LEFT("llog", 256) yyy
FROM "public"."users_info_ext";

/* ERROR:  function left(double precision, integer) does not exist
LINE 2:   , LEFT("llog", 256) yyy
^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. */

CREATE TABLE users_info_ext (
uin double precision NOT NULL,
pass text,
ulock smallint,
llog double precision,
iadr double precision,
bcst smallint,
cdate double precision,
cpass smallint,
nick text,
frst text,
last text,
email1 text,
email2 text,
email3 text,
e1publ smallint,
gmtoffs smallint,
auth smallint,
sex smallint,
age smallint,
bday smallint,
bmon smallint,
byear smallint,
waddr text,
wcity text,
wstate text,
wcountry integer,
wcompany text,
wtitle text,
wocup smallint,
wdepart text,
wphon text,
wfax text,
wpager text,
wzip text,
wweb text,
notes text,
haddr text,
hcity text,
hstate text,
hcountry integer,
hphon text,
hfax text,
hcell text,
hzip text,
hweb text,
nnotes double precision,
lang1 smallint DEFAULT 0,
lang2 smallint DEFAULT 0,
lang3 smallint DEFAULT 0,
hpage_cf smallint DEFAULT 0,
hpage_cat integer DEFAULT 0,
hpage_txt text DEFAULT ''::text,
wdepart2 text DEFAULT ''::text,
past_num smallint DEFAULT 0,
past_ind1 integer DEFAULT 0,
past_key1 text DEFAULT ''::text,
past_ind2 integer DEFAULT 0,
past_key2 text DEFAULT ''::text,
past_ind3 integer DEFAULT 0,
past_key3 text DEFAULT ''::text,
int_num smallint DEFAULT 0,
int_ind1 integer DEFAULT 0,
int_key1 text DEFAULT ''::text,
int_ind2 integer DEFAULT 0,
int_key2 text DEFAULT ''::text,
int_ind3 integer DEFAULT 0,
int_key3 text DEFAULT ''::text,
int_ind4 integer DEFAULT 0,
int_key4 text DEFAULT ''::text,
aff_num smallint DEFAULT 0,
aff_ind1 integer DEFAULT 0,
aff_key1 text DEFAULT ''::text,
aff_ind2 integer DEFAULT 0,
aff_key2 text DEFAULT ''::text,
aff_ind3 integer DEFAULT 0,
aff_key3 text DEFAULT ''::text,
iphide smallint DEFAULT 0,
webaware smallint DEFAULT 1
);

/* ERROR:  function substr(boolean, integer, integer) does not exist LINE 1: SELECT "id", SUBSTR("is_active", 0, 256)

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='YOUR_TABLE' AND TABLE_NAME='YOUR_DATABASE';

alter table geom add column geotest geometry(Point);
/* FEHLER:  Typ „geometry“ existiert nicht
LINE 1: alter table geom add column geotest geometry(Point) */

Selam

HeidiSql V : 9.5.0.5196

PostgreSQL V : 11

Database List empty.

I would like your help

When you installed PostgreSQL database server, the PostgreSQL installer also installed some useful tools for working with the database server. You can connect to the PostgreSQL database server by using the psql or pgAdmin tool.

Connect to PostgreSQL database using psql psql is an interactive terminal program provided by PostgreSQL. You can do a lot with psql tool e.g., execute SQL statements, manage database objects, etc.

The following steps show you how to connect to the PostgreSQL database server by using the psql program:

First launch psql program.

Second, enter all the required information such as the server, database, port, username, and password. If you press enter, psql will use default values inside the square brackets.

Third, you can interact with PostgreSQL database server by using various SQL statements. You can try the following statement to test it out:

1 SELECT version(); psql tool

Please do not forget to put the semicolon (;) at the end of the statement. After pressing enter, psql will give you the current PostgreSQL version that you have in the system.

Connect to PostgreSQL database using pgAdmin GUI application The second way to connect to a database is using pgAdmin GUI application. By using pgAdmin GUI application, you can interact with PostgreSQL database server via an intuitive user interface.

The following illustrates how to connect to a database using pgAdmin GUI application:

First, launch the pgAdmin application.

Launch pgAdmin

Second, double-click the PostgreSQL 9.2 under the Servers item. pgAdmin will ask you for the password. You have to provide the password for the postgres user. Once finish, click OK button to log in to the PostgreSQL server.

pgAdmin Enter Password

Third, choose the postgres database and click Execute Arbitrary SQL queries tool from the pgAdmin’s toolbar.

Launch SQL editor Fourth, enter the following statement:

Execute SQL query

Fifth, click the execute query button in the toolbar, pgAdmin will display the result in the output panel.

pgadmin output

Connect to PostgreSQL database from other applications Any application that supports ODBC or JDBC can connect to PostgreSQL database server. In addition, if you develop an application that uses an appropriate driver, the application can connect to the PostgreSQL database server as well.

In this tutorial, you’ve learned how to connect to PostgreSQL database server by using different client tools including psql and pgAdmin GUI application. Let’s explore the PostgreSQL database objects and find out how can we use them in our applications.

Thank you very much for your response.

I am actively using "SQL Manager" for PostgreSQL.

In my previous projects I was using MySQL - HeidiSQL ...

HeidiSQL has a lot of success and Easy to Use interface ...

When I see the posts for older versions of PostgreSQL, I have written in the hope that a study can be done for the current version ...

I thank HeidiSQL developer friends and wish them continued success.

Respects