How To Show Postgres Tables With Perl

Question

I have tried using the \d command inside perl and this is what i get

DBD::Pg::st execute failed: ERROR: syntax error at or near "d"

This is My Code

#!/usr/bin/perl

use DBI;

$myConnection = DBI->connect("DBI:Pg:dbname=test;host=localhost","postgres", "pass123");

$query = $myConnection->prepare("\d");
$result = $query->execute();


while(my @row = $sth->fetchrow_array()) {
      print "ID = ". $row[0] . "\n";
}

$myConnection->disconnect();

A backslash has a special meaning in a double-quoted Perl string. Either escape the backslash ("\\d") or use a single-quoted string ('\d'). — Dave Cross
– Dave Cross, Commented Jul 21, 2017 at 11:27
I would assume that \d is a command of the psql utility and not available as a SQL query via DBI. — dgw
– dgw, Commented Jul 21, 2017 at 11:31

Laurenz Albe · Accepted Answer · 2017-07-21 11:54:13Z

2

The simplest and most portable way is to use the table_info function.

answered Jul 21, 2017 at 11:54

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mivk · Accepted Answer · 2020-06-24 18:06:05Z

1

If you only want the list of tables or views, you can use

my @tables = $dbh->tables();

You can also restrict the list to a specific schema. For example, to get only the tables in the public schema, without the pg_catalog and information_schema tables:

my @tables = $dbh->tables(undef, 'public');

See https://metacpan.org/pod/DBD::Pg#tables for details.

For more information about the tables, use table_info as suggested in Laurenz' answer

answered Jun 24, 2020 at 18:06

mivk

15.5k5 gold badges89 silver badges83 bronze badges

Collectives™ on Stack Overflow

How To Show Postgres Tables With Perl

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related