I want to create a repository system where people can store videos, audios, pdfs, images, etc.
I will probably use PGSQL and wonder what the best strategy for storing this data is that it may be different in size and type.
Thanks in advance....
I saved an image in the postgresql database with the type OID and now I want to display this image on an html page tagged.
I checked that through lo_export I can send to a folder and read from there, but I wanted to read it directly without havi...
I'm new to pgSQL ... I use version 9.5.0 and need to update a column every time a new record is inserted.
The column must be populated from the values entered in area_pol and area_ofi.
I'm trying to create this function to meet my need:...
I have the following query
UPDATE teste SET
equacao = 'X*254/1024+15.2',
zerar = False,
MinValid = 0.00
WHERE id = 1
RETURNING *
It runs normally, but when I get to the database the plus + sign disappears: X*254/10...
I'm doing a page search system where I'll always do the following query in the database:
'SELECT title FROM pages ORDER BY title ASC OFFSET' +iniciaL + 'FETCH FIRST 32 ROWS ONLY'
I choose an initial OFFSET and always get the next 32. But I...
I was installing some functions in postgresql with mysqlcompact and I came up with the idea of developing a function that calculated the day of Easter so I did a search, but how do I convert this logic below to run psql postgreSQL? >
FUN...
Hello!
I have a situation ...
I have a table that will have about 3 * 10 ^ 12 lines (3 trillion), but with only 3 attributes.
In this table you will have the IDs of 2 individuals and the similarity between them (it is a number between 0 and 1 th...
How can I restore only one table from one bank to another?
I created the table backup from the following command in the CMD:
pg_dump -f C:\Backup\Backup_table.backup -t public.lotesretornosuprimento -d BancoDados
But I'm not finding how...
I installed the pypy of the following form:
wget https://bitbucket.org/pypy/pypy/downloads/pypy3-v5.10.1-linux64.tar.bz2
tar xf pypy3-v5.10.1-linux64.tar.bz2
virtualenv -p ~/pypy3-v5.10.1-linux64/bin/pypy my-pypy-env...