Questions tagged as 'postgresql-9.3'

Tagged questions
0
answers

functions checking parameter within a query

Let's see if someone can help me I have a table with id and a name, like this: id | first name 1 | Charles 2 | Pedro 3 | Juan and I want to create a function that by entering by parameter the id check me and I return the name of the id if the id...
asked by 18.03.2018 / 09:28
0
answers

syntax error when restoring a backup to psql

I have an error in the restoration of a backup in postgresql, the error that appears when trying to make the backup restore command is the one that I put in the title, the command that I use is the following psql -U postgres -d drogueria <...
asked by 02.03.2018 / 16:59
2
answers

How to read $ execute-fetch (PDO :: FETCH_ASSOC)?

Good morning stackoverflow community, I just want you to support to know what is my fault in the php code because when doing the while, it does not enter and does not print anything and I saw many pages and nothing has been served, I hope you fi...
asked by 12.12.2017 / 16:30
1
answer

How to make INNER JOIN between a table in SQL SERVER and a linked server?

Well I mean, I have a database in SQL SERVER called SIELAB and another database in PostgreSQL called reservations , I managed to make the connection correctly and I have already managed to execute a SELECT query from a stored procedure...
asked by 17.08.2017 / 04:20
0
answers

Read disk files with Postgresql

Hello, someone knows how to read files stored on the client machine disk from postgresql, also if it is possible to filter the search by the file extension. For example .SQL on sql server used EXECUTE master.dbo.xp_cmdshell 'dir /b "C:\Fol...
asked by 08.02.2017 / 01:37
1
answer

Create Store Procedure in PostgreSQL [duplicate]

I want to create a store procedure in PostgreSQL but I see that it always has a return, what I need is to make a simple LIKE I do not need to return anything, this is my query has syntax errors for example it is missing an AS after the name of...
asked by 11.01.2017 / 21:47
1
answer

PgAdmin freezes when trying to delete a table from the database

I have problems with a table in my database which was linked to geoserver. The layer was removed from geoserver but the table is still in the database. When you try to delete it with DROP TABLE, the program freezes, in fact just by touching the...
asked by 16.09.2016 / 17:05
1
answer

How do I create N cant of columns in an sql query? in postgresql

In the current query I have static to 2 columns, but I would like to create columns for each shift that is in another table. Here the 2 fiddle of what I have: sqlfiddle and dbfiddle Update 1 (trying to specify a little more): T...
asked by 18.03.2017 / 18:39