List All PostgreSQL Databases

Lists all PostgreSQL databases, their owners, encoding, and size. Equivalent to SHOW DATABASES in MySQL. Run from the psql prompt with \l or via command line.

When you need this: When auditing databases on a server or finding the correct database name.

Command


        

    







    2 views
    0 copies
    





    
    Log in to rate




    

        
Related in this category

        

                                                
                        Install PostgreSQL
                    
                                                                
                        Create PostgreSQL Database & User
                    
                                                                
                        Connect to PostgreSQL as postgres
                    
                                                                
                        Backup PostgreSQL Database
                    
                                    

    





        

        
            
                
            
            Log in to save
        
        
Free account — save snippets into your own collections.