Posts by p9adi • 51 points

• -1

  votes

  1

  answer

  111

  views

  Q: 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…

  php sql postgresql pdo date

  asked 5 years ago p9adi 51

• 0

  votes

  0

  answers

  52

  views

  Q: 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…

  database postgresql import

  asked 5 years ago p9adi 51

• 2

  votes

  1

  answer

  65

  views

  A: 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.

  php postgresql

  answered 7 years, 2 months ago p9adi 51

• 0

  votes

  1

  answer

  65

  views

  Q: 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:…

  php postgresql

  asked 7 years, 2 months ago p9adi 51

• 3

  votes

  1

  answer

  365

  views

  Q: 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…

  php html5

  asked 8 years, 9 months ago p9adi 51