Breaking News: Grepper is joining You.com. Read the official announcement!

postgres list schemas

TP answered on August 28, 2022 Popularity 9/10 Helpfulness 10/10

answer postgres list schemas

postgres list schemas

Comment

SELECT schema_name
FROM information_schema.schemata;

Alternatively, we can use:

 SELECT nspname
 FROM pg_catalog.pg_namespace;

Popularity 9/10 Helpfulness 10/10 Language whatever

Source: Grepper

Tags: list whatever

Link to this answer
Share Copy Link

Contributed on Aug 28 2022

0 Answers Avg Quality 2/10

Closely Related Answers

postgresql list all schemas

Comment

import psycopg2

# Connect to the PostgreSQL database
conn = psycopg2.connect(
    host="your_host",
    port="your_port",
    database="your_database",
    user="your_user",
    password="your_password"
)

# Create a cursor object to interact with the database
cursor = conn.cursor()

# Execute the query to retrieve all schemas from the database
cursor.execute("SELECT schema_name FROM information_schema.schemata")

# Fetch all the results as a list of tuples
schemas = cursor.fetchall()

# Print the list of schemas
for schema in schemas:
    print(schema[0])

# Close the cursor and connection
cursor.close()
conn.close()

Popularity 8/10 Helpfulness 1/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

postgres list schemas

Contents

More Related Answers

postgres list schemas

Closely Related Answers

postgresql list all schemas

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.