Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

PostgreSQL

B
Burma last edited by

Hello, everyone. Please recommend an adequate utilitator for postgreSQL, or that standard pgAdmin is not happy at all.
We need a convenient editor of requests with IntelliSense. Funds for the administration of OBD (recurrent copying, stopping, launching the server, etc.). Check the OBD system in diagram form. DS - Windows.
Reply Quote 0
1 Reply Last reply
irl last edited by

EMS SQL Manager for PostgreSQL
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

D

Filter on WHERE Postgresql
Software Programming • postgresql filter where • • Duquan

2

0
Votes

2
Posts

0
Views

N

I managed to solve my problem using a translate function.I'm going to paste SQL here for anyone interested in:SELECT a.id_alvara, a.id_alvara as numero, a.nome, a.firma, a.tipo_log||' '||a.logradouro||' '||a.complemento as endereco FROM alvara a JOIN atividade at ON a.id_atividade = at.id_atividade WHERE (translate(a.tipo_log||' '||a.logradouro||' '||a.complemento, translate(a.tipo_log||' '||a.logradouro||' '||a.complemento, '1234567890', '') , '')) = '220'
M

Query PostgreSQL 9.0 table on foreign key value?
SQL, Database Testing • postgresql query foreign key • • magpie

2

0
Votes

2
Posts

0
Views

T

"I'm certain every time that I'm bringing a gun to a knife fight, but my googling has been fruitless." What makes you think that? RDBMSs are built to 'join' If your aim is to make you SQL more readable then you might prefer the 'using' syntax: SELECT * FROM candies JOIN colors USING(color_code) WHERE color_value = 'blue'; alternatively, seeing as you are hard-coding 'blue' into your query, you could consider hard-coding the code instead: SELECT * FROM candies WHERE color_code = '02'; but this will decrease readability unless in your real-world scenario the codes are descriptive (eg 'BLU' for blue)
E

Wildcard subnet mask for IPv6
SQL, Database Testing • postgresql security • • emran

2

0
Votes

2
Posts

0
Views

S

The IPv6 wilcard subnet mask is ::/0
How can a sample be made from the MS SQL database?
Software Programming • sql server sql database • • Laycee

2

0
Votes

2
Posts

0
Views

There are several options:Less correct: create a submission (View) by placing the necessary fields from the tables and fields obtained from the groups.Better: write a stored procedure that will combine several SELECT into one common table.It is known that the correctly written stored procedures work faster than the submission by maintaining the implementation plan.
R

Why is a database much slower than the other in PostgreSQL?
Software Programming • postgresql database postgresql 9.3 • • Rossere

2

0
Votes

2
Posts

0
Views

T

In case someone else has this problem and can be helpful: I modified my postgresql configuration in /etc/postgresql/9.3/main/postgresql.confwork_mem = 2MB (por defecto es #work_mem = 1MB) And in a psql terminal I restarted the configuration (without service stop):SELECT pg_reload_conf(); To solve the problem I had to follow the lead Materialize of the query plan. So I could understand, Materialize recovers from disk (instead of memory). This is given when query is bigger than what you can store work_men. Anyway, if anyone could explain how he works exactly Materialize I would appreciate it since I have not found much information about it
J

How to perform UPDATE records after INSERT on Id, which returns INSERT. PostgreSQL
Software Programming • sql postgresql • • juvenalb

2

0
Votes

2
Posts

0
Views

T

Decided that: WITH ids AS (SELECT nextval('id_seq') AS id ) INSERT table (id, name, age, user) VALUES ((select id from ids),'user', 18, (select id from ids)||'user')
Service that automat update my database PostgreSQL
Software Programming • postgresql database servic languagee • • morde

2

0
Votes

2
Posts

0
Views

R

If you have the source files in some format supported by a https://www.postgresql.org/docs/current/static/ddl-foreign-data.html , you don't need to transform anything before you have access: simply create a link from Postgres to files using the FDW, so when you update the file, automatically what you receive in a SELECT be the most recent data, in the same structure as files, without the need to re-import data.Specifically from Excel you could use files in CSV format, using the https://wiki.postgresql.org/wiki/FDW#File_Wrappers
C

Insert PostgreSQL psycopg2
Software Programming • python postgresql • • charlenef

2

0
Votes

2
Posts

0
Views

P

I don't know why this is happening, but forced converting for all fields has helped. data = ( str(product["product_id"]), str(product["serial"]), str(product["code"]), str(product["name"]), str(product["article"]), str(product["label"]), str(product["release"]), str(product["format"]), str(product["package"]), str(product["count_disks"]), str(product["sounding"]), str(product["genres"]), str(product["weight"]), str(product["status"]), str(product["playlist"]), str(product["description"]), str(product["count_images"]), str(product["images"]), str(product["count_videos"]), str(product["videos"]) ) print("Добавление записи", data) database_resuest(sql, data) It happens because psycopg2 converts pitone type data into postgreas type. Maintains rows, numbers, ipiadres, owids. But your passer collects data from html and keeps them in type. Tag of which psycopg2 He doesn't know anything. It's possible wrong to check the type.Method .get_text() or text The text should be extracted from html. Maybe somewhere. contents Instead of a text in which an inserted tag was placed on one of the elements.
Transfer of parameters from C# to PostgreSQL
Software Programming • c sharp sql asp.net • • Demir

2

0
Votes

2
Posts

0
Views

B

I doubt you've ever tested a function, and you're already trying to call it from somewhere. The function can be checked directly in SQL-consoli pgAdmin: select metrolog.position_addtobject(<какие-нибудь параметры>); If all ok is in the same way and give you a function from programme C# or any other, through the SQL command (above), the request will return the line with the result, all as usual.
Regular Expressions Postgresql
Software Programming • postgresql regex trigger psql • • Laycee

2

0
Votes

2
Posts

0
Views

R

Guys managed to solve the problem here, was riding the regular expression wrong, here is the correct wayNEW.telefone ~ '^\+[0-9]{2}$[0-9]{2}$[0-9]{5}\-[0-9]{4}$'
T

What column type can store txid_current value?
SQL, Database Testing • postgresql • • tahishae

2

0
Votes

2
Posts

0
Views

O

I'm suspicious about your motivations, but I'd say you should either use bigint (which is the data type xid_current returns) or use xid (which is the internal data type for xid's). By way of example, see the following: pagila=# create table xidvals as select * from txid_current(); SELECT 1 pagila=# \d xidvals Table "public.xidvals" Column | Type | Collation | Nullable | Default --------------+--------+-----------+----------+--------- txid_current | bigint | | | pagila=# select xmin,xmax,txid_current from xidvals; xmin | xmax | txid_current --------+------+-------------- 358165 | 0 | 358165 (1 row) pagila=# select attname, atttypid::regtype from pg_attribute where attrelid = 'xidvals'::regclass and attname in ('xmax','xmin','txid_current'); attname | atttypid --------------+---------- xmax | xid xmin | xid txid_current | bigint (3 rows)
O

Create json from the postgresql table
Software Programming • postgresql • • obi

2

0
Votes

2
Posts

0
Views

A

Somehow:select json_build_object( 'id', array_agg(id order by id), 'nickname', array_agg(nickname order by id), 'name', array_agg(name order by id)) from tbl
G

Postgresql Two-phase Commit Transaction Identifier
SQL, Database Testing • postgresql transac languagetion • • guilherme

2

0
Votes

2
Posts

0
Views

J

So my solution was to simply not use the same transaction identifier across all databases. The Transaction Manager can keep track of the various identifiers and commit the databases accordingly. Seems ridiculously obvious so please correct me if I'm wrong.
D

How I can find out the foreign wrapper that a foreign table belongs to?
SQL, Database Testing • postgresql system tables • • derk

2

0
Votes

2
Posts

0
Views

This should do the trick: SELECT foreign_table_name, foreign_server_name FROM information_schema.foreign_tables You may find more information on information_schema.foreign_tables in the documentation.
SQLSERVER DATEDIFF in POSTGRESQL
Software Programming • php mysql postgresql base de datos • • emmalee

2

0
Votes

2
Posts

0
Views

D

You can use that same idea of the function DATE_PART but with some adjustments, for example, if you want the difference of months you must make a calculation with the years:SELECT (DATE_PART('year', now()::date) - DATE_PART('year', '2019-01-01'::date))*12 + DATE_PART('month', now()::date) - DATE_PART('month', '2019-01-01'::date) with the fields of your board:SELECT (DATE_PART('year', AGENTE.AGENTE_FECHA_RETIRO::date) - DATE_PART('year', USER.USER_FECHA_INCORPORACION::date))*12 + DATE_PART('month', AGENTE.AGENTE_FECHA_RETIRO::date) - DATE_PART('month', USER.USER_FECHA_INCORPORACION::date)

PostgreSQL

Suggested Topics

Filter on WHERE Postgresql Software Programming • postgresql filter where • • Duquan

Query PostgreSQL 9.0 table on foreign key value? SQL, Database Testing • postgresql query foreign key • • magpie

Wildcard subnet mask for IPv6 SQL, Database Testing • postgresql security • • emran

How can a sample be made from the MS SQL database? Software Programming • sql server sql database • • Laycee

Why is a database much slower than the other in PostgreSQL? Software Programming • postgresql database postgresql 9.3 • • Rossere

How to perform UPDATE records after INSERT on Id, which returns INSERT. PostgreSQL Software Programming • sql postgresql • • juvenalb

Service that automat update my database PostgreSQL Software Programming • postgresql database servic languagee • • morde

Insert PostgreSQL psycopg2 Software Programming • python postgresql • • charlenef

Transfer of parameters from C# to PostgreSQL Software Programming • c sharp sql asp.net • • Demir

Regular Expressions Postgresql Software Programming • postgresql regex trigger psql • • Laycee

What column type can store txid_current value? SQL, Database Testing • postgresql • • tahishae

Create json from the postgresql table Software Programming • postgresql • • obi

Postgresql Two-phase Commit Transaction Identifier SQL, Database Testing • postgresql transac languagetion • • guilherme

How I can find out the foreign wrapper that a foreign table belongs to? SQL, Database Testing • postgresql system tables • • derk

SQLSERVER DATEDIFF in POSTGRESQL Software Programming • php mysql postgresql base de datos • • emmalee

Filter on WHERE Postgresql
Software Programming • postgresql filter where • • Duquan

Query PostgreSQL 9.0 table on foreign key value?
SQL, Database Testing • postgresql query foreign key • • magpie

Wildcard subnet mask for IPv6
SQL, Database Testing • postgresql security • • emran

How can a sample be made from the MS SQL database?
Software Programming • sql server sql database • • Laycee

Why is a database much slower than the other in PostgreSQL?
Software Programming • postgresql database postgresql 9.3 • • Rossere

How to perform UPDATE records after INSERT on Id, which returns INSERT. PostgreSQL
Software Programming • sql postgresql • • juvenalb

Service that automat update my database PostgreSQL
Software Programming • postgresql database servic languagee • • morde

Insert PostgreSQL psycopg2
Software Programming • python postgresql • • charlenef

Transfer of parameters from C# to PostgreSQL
Software Programming • c sharp sql asp.net • • Demir

Regular Expressions Postgresql
Software Programming • postgresql regex trigger psql • • Laycee

What column type can store txid_current value?
SQL, Database Testing • postgresql • • tahishae

Create json from the postgresql table
Software Programming • postgresql • • obi

Postgresql Two-phase Commit Transaction Identifier
SQL, Database Testing • postgresql transac languagetion • • guilherme

How I can find out the foreign wrapper that a foreign table belongs to?
SQL, Database Testing • postgresql system tables • • derk

SQLSERVER DATEDIFF in POSTGRESQL
Software Programming • php mysql postgresql base de datos • • emmalee