This section describes how to execute queries using PostgreSQL remoting from any tool that can connect to PostgreSQL.

When executing queries, use a two-part name, in the format:

"<Schema Name>"."<Table Name>" 

where

• Schema Name is the name of the schema containing the table. In pgAdmin, the schema name is found in (your linked server name) > Databases > (your database name) > Schemas.
• Table Name is the name of the table you are querying data from.

SELECT Statements

To select records:

SELECT * FROM "Workday"."[CData].[Human_Resources].Workers" WHERE Legal_Name_Last_Name = 'Morgan' 

INSERT, UPDATE, and DELETE Statements

To insert, update, or delete a single row of data against a writable database, use the two-part name. For example:

INSERT INTO "Workday"."[CData].[Human_Resources].Workers" (Legal_Name_Last_Name) VALUES ('Morgan');