Posts Tagged ‘psql’

Transact-SQL, PL/SQL, PL/pgSQL defined and compared

  • PL/SQL is a proprietary procedural language used by Oracle
  • PL/pgSQL is a proprietary procedural language used by PostgreSQL
  • TSQL is a proprietary procedural language used by Microsoft in SQL Server.

TSQL is a proprietary procedural language used by Microsoft in SQL Server . Procedural languages are designed to extend the SQL ‘s abilities while being able to integrate well with SQL .Several features such as local variables and string/data processing are added.These features make the language Turing complete.

Quick Tip: Show Postgres/pSQL Tables in Postgres OR R in 1 Line

Outside of R:

\dt

In R:

dt <- dbGetQuery(con1, “SELECT * FROM pg_catalog.pg_tables”)