另一个数据库中对象的OBJECT_ID - 如何查找数据库ID或名称/完全限定对象名称？

SELECT name, database_id
FROM sys.databases
WHERE name = 'your_database_name'

SELECT SCHEMA_NAME, SCHEMA_ID
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'your_database_name'

SELECT datname, oid
FROM pg_database
WHERE datname = 'your_database_name'

import psycopg2

conn = psycopg2.connect(database="your_database_name", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

cur.execute("SELECT oid, datname FROM pg_database WHERE datname = 'your_database_name'")
result = cur.fetchone()

print(result)

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
    public static void main(String[] args) {
        try {
            Class.forName("org.postgresql.Driver");
            Connection conn = DriverManager.getConnection("jdbc:postgresql://your_host:your_port/your_database_name", "your_username", "your_password");
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT oid, datname FROM pg_database WHERE datname = 'your_database_name'");

            while (rs.next()) {
                System.out.println("Database ID: " + rs.getInt("oid"));
                System.out.println("Database Name: " + rs.getString("datname"));
            }

            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

psql -U your_username -h your_host -p your_port -d postgres -c "SELECT oid, datname FROM pg_database WHERE datname = 'your_database_name'"

mysql -u your_username -p -h your_host -P your_port -e "SELECT SCHEMA_NAME, SCHEMA_ID FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'your_database_name'"

sqlcmd -S your_host -U your_username -P your_password -Q "SELECT name, database_id FROM sys.databases WHERE name = 'your_database_name'"