Posts by p9adi • 51 points
5 posts
-
-1
votes1
answer111
viewsQ: PHP with PDO returns full SQL date
I have a PHP application that reads data from tables that can be SQL or Postgres. When I started using PDO instead of mssql, the SQL data fields return ex: 'Nov 29 2019 12:00:00:AM'. If you query…
-
0
votes0
answers52
viewsQ: Error connecting 2 postgres database with FOREIGN DATA WRAPPER
I’m trying to connect two postgre databases and I’m getting an error importing the tables: CREATE EXTENSION postgres_fdw; CREATE SERVER gestware_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS…
-
2
votes1
answer65
viewsA: Error connecting BD postgres with PHP
I’ve already figured it out. Stay here for anyone who has similar problems. The host server was blocking the output. I had to ask for permission to connect.
-
0
votes1
answer65
viewsQ: Error connecting BD postgres with PHP
I have Postgres 9.3 installed on a Windows server 2012. I need to collect BD information for a website. I’ve already set up the network router forwarding port 5432. On pg_hba I changed the line:…
-
3
votes1
answer365
viewsQ: Format SQL read variable hours and minutes presentation
I’m starting up PHP. I intend to present the hours and minutes stored in a field but when I read it what it presents is something like: 01:00:00.0000000. The SQL field is time(7) and the variable…