Postgresql – How to change owner of PostgreSql database postgresql I need to change the owner of PostgreSql database. How to change owner of PostgreSql database in phppgadmin? Best Answer ALTER DATABASE name OWNER TO new_owner; See the Postgresql manual's entry on this for more details. Related SolutionsPostgreSQL “DESCRIBE TABLE” Try this (in the psql command-line tool): \d+ tablename See the manual for more info. PostgreSQL: Show tables in PostgreSQL From the psql command line interface, First, choose your database \c database_name Then, this shows all tables in the current schema: \dt Programmatically (or from the psql interface too, of course): SELECT * FROM pg_catalog.pg_tables; The system tables live in the pg_catalog database. Related TopicPostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQLSql – Save PL/pgSQL output from PostgreSQL to a CSV filePostgresql – How to drop all the tables in a PostgreSQL databasePostgresql – How to drop a PostgreSQL database if there are active connections to itPostgresql – How to exit from PostgreSQL command line utility: psqlPostgresql – How to change PostgreSQL user passwordPostgresql – Which version of PostgreSQL am I runningPostgresql – psql: FATAL: database “” does not exist
Best Answer
See the Postgresql manual's entry on this for more details.