richard coleman <rcoleman.ascentgl@xxxxxxxxx> writes: > Thanks, but no. I am looking for the SQL statement. > I very rarely venture into psql, unless it's to run an SQL code block from > the terminal. > Is there an SQL way to do this? psql is still a useful reference. Run it with the -E option and look at the SQL it issues when you say "\l". Trim to fit your requirements. regards, tom lane