phppgadmin | the premier web-based administration tool for postgresql | SQL Database library

Just as the title says, I want to duplicate one table from a completely separate database in phpPgAdmin to another one. I have tried two ways but both did not work for me:

1. Tried "Create table like" (database >> table >> create table like)
   • this seems to can only duplicate a table within the database
2. Tried export and import
   • I tried to export the table I want, then heading over to the other database and try to import in an empty table. but the error i am getting is either "Import error: File could not be uploaded to the server phppgadmin" or "Import error: Failed to automatically determine the file format."

I am trying to connect to a remote postgresql database using the bitnami/phppgadmin docker

How to mention the host name

I just started with PostgreSQL. Since we use a lot of Unixtimestamps I figured it would be best to just try a little example. So I made a table test with a field ID and a field timestamp of type timestamp without time zone using phpPgAdmin. There is valid data.

Now I just wanted to retrieve the data using a Unixtimestamp. And I run into really odd behavior.

I made this little test which selects data by just converting the first best timestamp into a unixtimestamp and back into a timestamp:

This will return the timestamp in the raw and unix value for the first entry

I'm trying to implement a (hopefully) simple login system using PHP and PostgreSQL.

This is the postgres table containing usernames and hashed passwords.

Users are not meant to be able to create new rows in this table so I already hashed the passwords using password_hash('password', PASSWORD_BCRYPT) and then manually copypasted the value in the table.

Let me know if you think this could pose a problem.

Users can, however, login to an already existing account by inputting the right username and password combination into a login form.

When the login button is pressed I need to retrieve information about the user entered, so that if it matches any user I can then verify the password using password_verify().

When the login button is clicked I run this code:

NOTE: This is not about which better database, not at all.

Hi, my client has a shared host with the following stack: PHP: 7.x.x MySQL: 5.6.x Postgres: 9.2.x PhpMyAdmin PhpPgAdmin

I'm able to use both MySQL(PHP) and PostgreSQL(C#, Go, Python, JS), but I personally prefer Postgres, also my client's host specs make it harder to use some SQL features like CTE which have no support in MySQL 5.6 (I know 8.0 has them).

The problem: I plan to use Postgres, but I'm a little concerned about the combination of PHP+Postgres, since it seems that most PHP development is coupled with MySQL, for example, PhpMyAdmin is activly developed compared to PhpPgAdmin (the last release from 2018), also it seems it ALWAYS assumed that PHP runs using MySQL while Postgres is like a second citizen.

So, in your experience, should I go with Postgres or MySQL, to minimize the trouble that may arise? Thanks.

I want to execute some SQL commands on the database level in postgresql in linux machine. I want to learn the command line

Eg: i want to run the SQL. I have a role created called somesuperuser using phppgadmin.

Install based on https://www.howtoforge.com/tutorial/ubuntu-postgresql-installation/ in my ubuntu 16.04

Log into http://localhost/phppgadmin/ PostgreSQL, browser show Version of PostgreSQL not supported. Please upgrade to version or later.

Any resolution?

In my docker project with postgres 9.6 I need to add support for uploading of big sql dumps. I added pg_dump by adding in my web/Dockerfile.yml file line:

I'm updating a Linux server with a new version of PostgreSql and I have an Error Message in phpPgAdmin when I browse a table.

The Ubuntu 18.04.3 LTS server running Apache 2.4.41, PHP 7.3.11 and when I update to PostgreSQL 12.0 and phpPgAdmin 7.12.0 the error occurs. With PostgreSQL 11.5 and phpPgAdmin 5.6 I didn't have this problem.

I expect to visualize the data stored in the table using phpPgAdmin, but the actual output is: