17 февр. 2011 г. · This lists databases: SELECT datname FROM pg_database WHERE datistemplate = false; This lists tables in the current database.

5 февр. 2014 г. · The function current_database() returns the name of the current database: SELECT current_database(); It's an SQL function, so you must call it as part of an ...

27 нояб. 2017 г. · If you only want to see the list of databases and have psql available to you, you can simply use -l to list and exit.

8 авг. 2014 г. · I could use psql --list|grep UTF8|awk '{ print $1 }' to get a list of just the databases. Can psql also give me a clean useful list directly?

11 янв. 2021 г. · The following is more readable: SELECT datname FROM pg_database WHERE NOT datistemplate AND datallowconn AND datname <> 'postgres';

6 сент. 2012 г. · You can show all user-defined and system views in the current database with information_schema.views and pg_proc as shown below.

15 апр. 2013 г. · To lists all schemas, use the (ANSI) standard INFORMATION_SCHEMA select schema_name from information_schema.schemata;

3 авг. 2011 г. · You can do that by following: SELECT grantee, privilege_type FROM information_schema.role_table_grants WHERE table_name='mytable'

20 авг. 2016 г. · To be able to list all the databases of a PostgreSQL database server with RazorSQL, one has to first connect via JDBC to the PostgreSQL database server.

3 сент. 2013 г. · I want to use psql to list all of the databases on a Postgres server, to be parsed by a script. This command lists them: psql -l -A -t but the output shows an ...